Records does not match query

[icebox27]

Good day everyone!

Need help about this one.

I need to select the records in table A that do not exist in table B.

Feel free to clarify things if my question is vague.

Thanks in advance!

Regards,

[dafodil]

Good day everyone!

Need help about this one.

I need to select the records in table A that do not exist in table B.

Feel free to clarify things if my question is vague.

Thanks in advance!

Regards,

Please give a detailed explanation and the sample of datas you want to retrieve.

[icebox27]

Considering the following data.

Table A

apple
banana
cat
peach

Table B
apple
banana
peach
dog

I wanted to display the record "cat", since it cannot be found in Table B.

Thanks!

[comlink21]

Please give a detailed explanation and the sample of datas you want to retrieve.

SELECT * FROM A WHERE NOT IN (SELECT * FROM B )

[icebox27]

exactly the answer I was looking for!

Thanks a lot!

[dafodil]

SELECT * FROM A WHERE NOT IN (SELECT * FROM B )

Good post comlink21
.
You can also use this:

SELECT * FROM A WHERE NOT EXISTS (SELECT * FROM B)