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

  • strotram meaning

    शृणु त्वं कथयामि देवि देहस्यं ज्ञानमुत्तमम्।येन विज्ञानमात्रेण सर्वज्ञत्वं प्रणीयते।। स्वरे…

  • Intro in Sanskrit

    नमः, मम नाम विशिः अस्ति।Namaḥ, mama nāma Viśiḥ asti. अहं…

  • small conversation in sanskrit

    hello नमो नमः what is your (thou) name [male]? भवान्…