> I think I love you. > > :)
how sweet...my first 2003 Valentine... But I can't take credit. I think either Sam Neff or Jochem van Dieten contributed this little gem to the CF-Talk list recently. I'm just the messenger. :) ----- Original Message ----- From: "Scott Weikert" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, February 11, 2003 5:08 PM Subject: Re: Is there a better way to do this...? > At 04:47 PM 2/11/2003 -0600, Dina Hess wrote: > >Have you tried this? > > > >select * > >from table1 LEFT JOIN table2 ON table1.id = table2.id > >where table2.id IS NULL > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
