Using a LEFT JOIN
To isolate the uncommon rows in the table one
SELECT t1.*
FROM Table1 t1
LEFT JOIN Table2 t2 ON t1.id = t2.id
WHERE t2.id IS NULL;
using Except if database supports.
SELECT * FROM Table1
EXCEPT
SELECT * FROM Table2;
UNQORK
In unqork we use datawork flow.
the merge operator is used with outer option.
upper node will have table one and below node will have table two.
Leave a Reply