Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement