Re: Selecting all from tbl A that does not exist in tbl B

[Nick Roper]

Hi Fredik,

Try:

SELECT B.id as 'No match' FROM B LEFT JOIN A
ON B.id = A.id
WHERE A.id IS NULL;

Hope this helps,

Nick

--
Nick Roper