Re: OT:SQL prob

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. > > > SELECT r.eventID, d.title > FROM Events r, > EventDescription d > WHERE d.eventID = r.eventID > > > This quer

OT:SQL prob

SQL Server 7. SELECT r.eventID, d.title FROM Events r, EventDescription d WHERE d.eventID = r.eventID 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 des