Page 1 of 1

Query Problem

Posted: Mon Apr 10, 2006 5:04 pm
by stebut05
Hi, thanks for reading this post.

I have been trying to query two tables and return the results from the query

Code: Select all

"SELECT * FROM signOff, mechanicSignHistory WHERE signOff.taskID NOT IN (mechanicSignHistory.taskID)"
Basically i want the query to return or the rows where taskID exists in signOff Table and NOT IN mechanicSignHistory. I think the above sql query is correct, but no rows are being returned. I really appreciate any thoughts, comments, help, etc.

Regards,


Steevn

Posted: Mon Apr 10, 2006 10:46 pm
by feyd
have a look through the Useful Posts thread.

viewtopic.php?t=29816