>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
Should not be a problem. You can post your SQL here.
Mark McCasland
Midlothian, TX USA