Thanks for the replies.

I have actually found a way around this.

If I SET DELETED OFF before the selected, then run

SELECT table1.*,table2.*;
FROM table1 LEFT OUTER JOIN table2;
ON table1.key = table2.key;
WHERE !DELETED("table1")

It will bring me the non-deleted records from the 1st table and ALL records from the 2nd table.

Thanks
Kev