Query Problem

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
stebut05
Forum Commoner
Posts: 35
Joined: Wed Sep 21, 2005 9:29 am
Location: Liverpool, UK

Query Problem

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

have a look through the Useful Posts thread.

viewtopic.php?t=29816
Post Reply