/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 vote357 views1 answer
Isolate digits in large number cpp
TypeScript
0 vote347 views1 answer
Header elements on right
TypeScript
1 vote334 views2 answers
Verify if object is of a certain type type in typescript
TypeScript
0 vote325 views1 answer
React forwardref typescript
TypeScript
0 vote302 views1 answer
Not able to use fonts awesome in react
TypeScript
1 vote320 views1 answer
No provider for ChildrenOutletContexts Angular
TypeScript
0 vote305 views2 answers
Get elements of array matlab
TypeScript
2 votes304 views1 answer
All elements that begin with r
TypeScript
0 vote342 views1 answer
Meta tag utf-8 means kya hota hai
TypeScript
0 vote288 views1 answer
Typescript watch mood
TypeScript