OOPS!! Correction below

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