I am having a very strange problem with SQL 2000. I write a simple LEFT
OUTER JOIN query, and it returns only the records where there are matching
records on both tables (no different from an INNER JOIN).
Below is an example of a query that I have run:
select a.movieno, b.movieno
from lst_movies a
left outer join lst_fcstMaster b
on a.movieno = b.movieno
where b.fcst_number = 12
the table lst_movies contains approximately 7000 records. The lst_fcstmaster
table contains only 65 (where the field fcst_number = 12).
The result set is only 65 records and not 7000.
Thanks for any help