I have an answer set of 60 records called Table A. Table B has 30 records which are derived from Table A. Table C contains another 20 records from Table A. If I want to retrieve the remaining 10 records from Table A. Can I use NOT IN i.e. Select Account from A where Account not in (Sel Account from B) and Account not in (Sel Account from C)? or is there better way to do it?
asked Jul 13 '10 at 05:59 AM in Default
That's just fine.
The other way to do it is using [EXCEPT]
: h ttp://msdn.microsoft.com/en-us/library/ms188055.aspx
answered Jul 13 '10 at 06:01 AM
Matt Whitfield ♦♦