Hi

I have a select with two tables that LEFT OUTER JOIN, I want the joined table to include it's deleted records as well as the non-deleted ones.

Any ideas on how to sort this? I have tried SELECT.....WHERE DELETED("table2") OR !DELETED("table2").

Thanks
Kev