I just need in english how you would check a value against
a lookup table (IN)?
What does "(IN)" mean. My boss just wrote it down so I
dont know if it is part of the question?
Thank you so much for the above answers.
(perhaps you want to
>I think DISTINCT ROW is syntax of ACCESS , in T-SQL[/ref]
DISTINCT is the same
>Let assume you have two tables
>SELECT * FROM Table1 WHERE Table1.col NOT IN (SELECT[/ref]
table2.col FROM Table2 [/ref]