sql missing records from another table how to get the elements that missing in other tables sql

The solution for “sql missing records from another table how to get the elements that missing in other tables sql” can be found here. The following code will assist you in solving the problem.

— Returns missing my_table1 ID in my_table2
SELECT DISTINCT t1.* FROM my_table t1
LEFT OUTER JOIN my_table2 t2
ON t1.ID = t2.ID
WHERE t2.ID is null;
— Or:
SELECT t1.* FROM my_table1 t1 WHERE NOT EXISTS
(SELECT ID FROM my_table2 t2 WHERE t2.ID = t1.ID);
— Or:
SELECT t1.* FROM my_table1 t1 WHERE t1.ID NOT IN
(SELECT ID FROM my_table2 t2 WHERE t2.ID = t1.ID);SELECT A.ABC_ID, A.VAL FROM A WHERE NOT EXISTS
(SELECT * FROM B WHERE B.ABC_ID = A.ABC_ID AND B.VAL = A.VAL)

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

0
inline scripts encapsulated in