General information
Category:
Coding, syntax & commands
Title:
Help with SQL statement
I 'll make this as simple as possible:
I have three tables: Projects, Tapes, & Featpersons. I have an SQL statement with ( Projects INNER JOIN Tapes ) along with ( Tapes LEFT JOIN Featpersons ) and it works fine at this point. However, I have a fourth table that needs to also do a ( Tapes LEFT JOIN checkedout ) in
order to show if the found tapes are in the library or not. I have an IIF() in the SQL statement which processes this nicely. This fourth table can relate via the same field (ctl_index) as featpersons or via another (tapeID) field if it JOINS with Tapes.dbf
Here's the problem: Apparently a table cannot be involved in two simultaneous LEFT JOINS, or I have my syntax wrong. Any help/guidance would be greatly appreciated, and I can e-mail the SQL if necessary.
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only