if you are using ms sql to build the query, right click the joining line in the query builder and select to return all rows in the relevant table, this does the appropriate join for you.
Jenny ----- Original Message ----- From: "Adrian Lynch" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, September 29, 2005 1:55 PM Subject: RE: query question > Yup. Look at left and right outer joins. > > http://www.w3schools.com/sql/sql_join.asp > > What DB are you using? > > Ade > > -----Original Message----- > From: Mark Fuqua [mailto:[EMAIL PROTECTED] > Sent: 29 September 2005 13:45 > To: CF-Talk > Subject: query question > > > Morning, > > When I use joins with a select statement, and one of the columns in the > query is blank, that record is not part of the record set. I would like > to > include the records with missing columns and have those columns just be > blank. Is that a possibility? > > Thanks, > > Mark > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219621 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
