Help with query 1

[pkailas]

I have 2 tables

Invoices106
DocTypeRecNum     KeywordNum
9                 100
10                102

Keywords
KeywordID    KeywordName    DataType    Length
100          Invoice Number adVarWChar  50
101          Invoice Date   adDate
102          Vendor Name    adVarWChar  100

The result I need is from the Keywords table

KeywordID    KeywordName    DataType    Length
101          Invoice Date   adDate

In other words, I need to find which KeywordID's are in the Keywords table but NOT in the Invoices106 table.

 

[Lothario]

Try this...

SELECT KeywordID, KeywordName,DataType, Length FROM Keywords WHERE KeywordID NOT IN (SELECT KeywordNum FROM Invoices106)

-L

 

[pkailas]

Thanks. I had already figured that out, but your answer is correct and therefore worth a start!