oops i meant WHERE ((members.memNumber) Is Null); > -----Original Message----- > From: Harkins,Patrick [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 16, 2002 3:59 PM > To: CF-Community > Subject: RE: Db merge question
> 1. qryNewGuys > > SELECT DISTINCTROW tmpMembers.memNumber, tmpMembers.Region, > tmpMembers.Phone > FROM tmpMembers LEFT JOIN members ON tmpMembers.memNumber = > members.memNumber > WHERE ((members.User) Is Null); > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_community Get the mailserver that powers this list at http://www.coolfusion.com
