Query question

[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.

 

[Brendan Reynolds]

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

 

[Danny J. Lesandrini]

Something like this ...

SELECT AllTable.ID, AllTable.TextValue
FROM AllTable
LEFT JOIN MinusTable
ON AllTable.TextValue = MinusTable.TextValue
WHERE MinusTable.TextValue IS NULL

or, you could link on ID, if that defines the relationship.

 

[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.

Thank You!!