/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

-1 vote221 views1 answer
Typescript http get attach headers
TypeScript
0 vote208 views1 answer
Angular type of string
TypeScript
1 vote262 views1 answer
Eslint missing file extension ts
TypeScript
1 vote220 views1 answer
A function that prints all numbers from 0 - n Added together python
TypeScript
2 votes298 views1 answer
'mat-checkbox' is not a known element
TypeScript
0 vote221 views1 answer
Run an applescript
TypeScript
0 vote228 views2 answers
Rails precompile assets in a directory
TypeScript
9 votes221 views4 answers
Angular scroll to top
TypeScript
1 vote204 views1 answer
Angular ngfor conditional pipe
TypeScript
4 votes214 views1 answer
Ionic toast
TypeScript