CR X1

I have two tables - a stock master and sales history and I want to look at products that are in the stock master and do not appear in the history table in a date range.

In other words products where there are no records in a given date range in the sales history table.

I have tried left outer join, but it does not appear to work as I expected.

I expected all 53,169 records to be returned from the stock master table, with nulls where there was not a matching sales history record.

Instead the result gives me 4,115 records and no null fields.

Any suggestions?

Thanks