2007.11.19 10:38 PM
SQL Server Left Anti Semi Join?
Irena Kennedy explains in the context of a "Good SQL Interview Question". You can add to her two examples the SQL Server 2005 EXCEPT operator, which, if you're keeping score at home, is SQL Server's answer to the old Oracle MINUS set operator. Btw, the SQL Server 2005 INTERSECT operator is a left semi join.
TrackBack URL: http://www.typepad.com/services/trackback/6a00d8341c7bd453ef00e54f9d1dfa8834
Listed below are links to weblogs that reference SQL Server Left Anti Semi Join?: