|
Hi Friends, I was trying to finetue a query and come across a piece of code written by some expert developer and I could not understand what the second clause in this query meant for.One in which he is using " 1>=" for count of join based on column of outer query SELECT COL1 , FROM TAB1 )
(comments are locked)
|
|
It looks to me as though the query is looking to return only items in Tab1 where there's at most one item in Tab2.
(comments are locked)
|


Is there any way to rewrite this query without subquery