Query help

[Richard Reina]

I have two tables:

EVENT
ID        name                             date                  sponsor_ID
23       Sady Hawkins              2004-11-04       235
89       Founders Day               2004-12-21       NULL
87       Winter Gala                  2004-01-23       NULL
SPONSOR
ID      name              
235   George Suter
34      William Riggs
896    Lidia   Bronson

I am having trouble writing a query that joins both tables but will pull 
up an event even if it  DOES NOT have a sponsor. 

SELECT FROM e.name, e.date, s.name
FROM event e, sponsor s
WHERE e.sponsor_ID = s.ID
This query works only for those events that have a sposor.

Any help would be greatly appreciated.

Richard

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]