Query Question

  • Thread starter Thread starter Claude Amyotte
  • Start date Start date
C

Claude Amyotte

HI Again gang.

I posted a question a few hours ago regarding this and unfortunately I lost
the answer. Can someone please re-post it? Thanks. It was regarding a query
that has a table that I want to show all the data of except for the data in
another table. I want that data not to show in my list box(take out already
assigned data) I thought I remembered it but I can't quite get it. Thanks.

Claude.
 
Well, Brendan Reynolds gave the elegant answer ...

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


and I posted this ...

SELECT AllTable.ID, AllTable.TextValue
FROM AllTable
LEFT JOIN MinusTable
ON AllTable.TextValue = MinusTable.TextValue
WHERE MinusTable.TextValue IS NULL
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query question 3
Report Query Works 2nd Time, But Not 1st 14
Query Question 5
Ansswer for my question 1
Access #Error & Excel Pivot 0
Dmin in Access query design 0
Update query error: "Operation must use an updateable query." 3
Making a query that creates a value base on a table value 8

Back
Top