To separate the uncommon rows of one table (rows that exist in one table but not in another)

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

Your email address will not be published. Required fields are marked *

More Articles & Posts