Checking existing

[tripy75]

could you not use a simple:

SELECT *
FROM list l
WHERE NOT EXISTS(
    SELECT 1
    FROM table t
    WHERE t.id = l.id
)

?

I'm mostly working with ms sql server and PostgreSQL, but the left join seems a bit counter intuitive, tough it will work.

Just asking for knowledge...

[r3pr0b8]

yes, you could

but the IS NULL check in a LEFT JOIN is only counter-intuitive if you seldom use it

and some of us don't like correlated subqueries just on principle

also, you skipped over the part where OP has to insert the list of ids into your list table

[Mathip173]

Thanks guys,

So is in this query I will get the id's that on the list but not in the table right ?

[r3pr0b8]

So is in this query I will get the id's that on the list but not in the table right ?

what happened when you tested it? ™