Forum Discussion

Sebastian's avatar
Sebastian
Icon for Advocate III rankAdvocate III
10 years ago

function like "not in"

Hi all,   did there still exist a function like "not in"?   I try to find values which are maybe in the one table but not in another one.   could someone help?   Thanks.
Need Help
Sebastian's avatar
Sebastian
Icon for Advocate III rankAdvocate III
10 years ago

Hey. Thanks for your answer.

 

The except function doesn't work.

 

My problem:

 

I have a table (table 1)  which consist of all customer information and a second table (table 2) which consist of sales information.

I try to find all customer who are in table 1 but not in table 2.