Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I add missing records to a table from a second table? I want to add records from 2nd table which do not exist in first table, while ignoring duplicates.
I figure I can use the Outer join.
Hi,
The outer keyword is optional and is the default join type used when a join prefix is not specified. So there is no need to put outer.
Hope this helps
You may Concat 2nd table with Where not exists clause, before that you would need to create temp key field like this in first table -
Keyfield as tempkeyfield,
and then while loading 2nd table -
Where not exists(tempkeyfield,keyfield)
