Query question

C

Claude Amyotte

Hi gang. I have a situation in a list box where I need to display all the
data from one table minus the data from another table(already assigned
data). I know I've done this before but for the life of me I can't get it
to work. I've tried not like and not in but doesn't seem to work - displays
all the data anyway. Thanks.

Claude.
 
B

Brendan Reynolds

SELECT * FROM FirstTable WHERE PrimaryKeyField NOT IN (SELECT
PrimaryKeyField FROM SecondTable)
 
C

Claude Amyotte

Hi gang. I have a situation in a list box where I need to display all
the data from one table minus the data from another table(already
assigned data). I know I've done this before but for the life of me I
can't get it to work. I've tried not like and not in but doesn't seem
to work - displays all the data anyway. Thanks.

Claude.
Click to expand...

Thank You!!
 
Top