SQL Query Question

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi Everyone,

I am having some problems with a query on an ASP web page.

Situation is that I have two tables, as shown below. 

I am trying to generate a recordset where the result is all reocrds from Table1 where Table1 ID = Table2 JobID and Table2 UserID does not equal a certain number (querystring).

This should give me all jobs in Table1 that the querystring has not been assigned. Make sense?
 -----------------------
Table1
ID (Auto)
JobAddress

Table2
ID (Auto)
JobID
UserID
-----------------------

I hope someone can help.

Thanks.