Hi All:
I have two tables: event and event_times.
Event is connected to event_times with left outer join. When I run my view, I get result set as if the two tables are inner joined. What am I doing wrong? This is on sql 2000.

Thanks

SELECT dbo.events.event_title
FROM dbo.events LEFT OUTER JOIN
dbo.event_times ON dbo.events.event_id = dbo.event_times.event_id