I simplified version went something like this: Select * from t1 where exist (select .null. from t2 where t2.key = t1.key)
Tracy -----Original Message----- From: Michael J. Babcock, MCP Sent: Wednesday, September 26, 2007 4:43 PM Either Alan Stevens or Dave Bernhard (I thought) had a neat cool trick with sub-selects where they took advantage of NULL somehow to short circuit the result, iirc. Can anyone recall it and repost here? I looked in my session notebook but apparently didn't write the tip in there. tia! --Michael _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
