SQL Filter Table by values in another table
Posted on 2012-09-20
Hi there, I am trying to build a sql query where the results in table one do not equal the results in table two.
Table1 Fields: ID
Table2 Fields: Item, String
String is filter by the parameter @string.
When the query executes I want Table1.ID to show all records except what table2 records shown by the filter.
I am very new to SQL syntax and am not sure how to join table1 and table2 to get the desired results. Any help would be greatly appreciated!