Subscribe to this blog
Archives: September 2011
NOT IN or IN?
I have been having a hard time believing my eyes when I noticed that these queries give different results:
1. select * from TableA a where a.a_id not in (select b.a_id from TableB b)
2. select * from TableA a where not exists (select b.a_id from TableB b where a.a_id=b.a_id… Read more
0 comments, 261 reads
Posted in aedna@SQL on 27 September 2011