Query Problem
Posted: Mon Apr 10, 2006 5:04 pm
Hi, thanks for reading this post.
I have been trying to query two tables and return the results from the query
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
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)"Regards,
Steevn