/TypeScript/How to get the elements that missing in other tables sql

How to get the elements that missing in other tables sql

Sql missing records from another table

-- 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);

How to get the elements that missing in other tables sql

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)

Source: stackoverflow.com

Similar codes

0 vote246 views1 answer
Ubuntu hosts file location
TypeScript
15 votes261 views3 answers
Can't bind to 'formGroup' since it isn't a known property of 'form
TypeScript
1 vote231 views1 answer
Iterate object ngfor
TypeScript
0 vote258 views1 answer
Sts shortcut to resolve error
TypeScript
1 vote264 views2 answers
Show all posts from category
TypeScript
63 votes462 views6 answers
React router install
TypeScript
0 vote243 views1 answer
Flutter allow user to select text
TypeScript
0 vote242 views1 answer
Difference between statistical learning and machine learning
TypeScript
1 vote190 views1 answer
Undefined string typescript
TypeScript
7 votes249 views2 answers
How to fix from PyQt5 import QtWebEngineWidgets error
TypeScript