SELECT r.eventID, d.title FROM Events r LEFT JOIN EventDescription d ON d.eventID = r.eventID
On Apr 5, 2005 3:17 PM, Dave Francis <[EMAIL PROTECTED]> wrote: > > SQL Server 7. > > <cfquery name="q1" datasource="newStuff"> > SELECT r.eventID, d.title > FROM Events r, > EventDescription d > WHERE d.eventID = r.eventID > </cfquery> > > This query only returns rows from "Events" table that have eventID present > in "EventDescription" table. I need to return ALL rows from Events table > whether thay have a description or not. > > As ever, thanks in advance, > Dave > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:201491 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
