I have a query of a left outer join
CREATE TABLE table3
AS SELECT d.*, u.*
FROM table1 d
LEFT OUTER JOIN table2 u
ON (d.id = u.sgno);
What i would like to do within the same query is to be able to create a new
table with all the records of table2 that are not joined to table1.