Welcome to Geekdojo Sign in | Join | Help

October 2004 - Posts

T-Sql: Join and 'Not In' vs Exists and 'Not Exists'

Jignesh Desai writes on our UG Forum :- Intersect you can achieve using joins also....Select Jignesh.Topic From Jignesh, NaveenWhere Jignesh.Topic = Naveen.Topic.[update: this would include repetitions of the topic] Minus query can be formed as :-Select
posted by richardhsu | 5 Comments
Filed Under: