Hi all,
Thanks for looking at my thread, would appreciate as much help as possible even though its a bank holiday!! Here it goes, it have a really difficult query to perform, well difficult for me. I need to query a few tables to show repeated results.
Cards - CardID (PK)
Tasks - TaskID (PK), CardID (FK)
SignOff - TaskID (FK), NoBoxes
InspecSign - TaskID (FK)
MechSign - TaskID (FK)
Basically i want to display all the rows from the Task table where the CardID in the table is equal to the cardID on card table and where CardID in card table is equal to '$cardID'.
This is where its gets complicated. In the task table some task might have a signOff if so then i want to display the NoBoxes, but some tasks dont have signOff. Do i do a join on this query, if so, any ideas??? thanks in advance for any help, advice, etc
Regards,
Steven
