Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
theboyholty
Posting Yak Master
226 Posts |
 Posted - 2009-08-11 : 11:09:45
|
| Is there a Union operator or something similar which would just show me the difference between two result sets?For example.select exampletext,'q1' as source from whereverunionselect exampletext,'q2' as source from whereverorder by source,exampletextproduces:aaa,q1bbb,q1ccc,q1aaa,q2bbb,q2The difference being the 'ccc' that query 1 produced. I want the result of my query to ONLY show the ccc,q1---------------------------------------------------------------------------------http://www.mannyroadend.co.uk The official unofficial website of Bury Football Club |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-08-11 : 20:00:12
|
| Does this fit your needs?select exampletext,'q1' as source from whereverEXCEPTselect exampletext,'q2' as source from whereverorder by source,exampletext=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
 |
|
|
|
|
|
|
|
Union question