/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

3 votes36 views1 answer
Sort list of lists by first element
TypeScript
1 vote37 views1 answer
Adonisjs hooks
TypeScript
0 vote41 views1 answer
Error: ENOENT: no such file or directory, stat '/home/alafia/.steampath' npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] start: `react-scripts start` npm ERR! Exit status 1
TypeScript
0 vote38 views1 answer
Check if graphic driver exists ubuntu
TypeScript
1 vote31 views1 answer
Main concepts in asp.net core
TypeScript
1 vote40 views1 answer
Typescript dynamic key value object
TypeScript
0 vote35 views1 answer
Oracle objects in tablespace
TypeScript
0 vote39 views1 answer
Unknown compiler option 'files' nativescript
TypeScript
0 vote38 views1 answer
Module '"@angular/fire/firestore"' has no exported member 'AngularFirestoreDocument'
TypeScript
1 vote34 views1 answer
Typescript filter list by property
TypeScript