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, 2010 at 05:59 AM in Default