Tracy Pearson wrote: > I simplified version went something like this: > > Select * from t1 where exist (select .null. from t2 where t2.key = t1.key)
How is this different from: select * from t1 where exist (select t2.key from t2 where t2.key = t1.key) BTW, the selecting of .null. intrigued me so I tried it in VFP8. Check out the funky result: http://paulmcnett.com/vfp/vfp8_null.png ;) -- pkm ~ http://paulmcnett.com _______________________________________________ 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.
