Multiple table JOIN???
Posted: Fri Feb 19, 2010 7:59 am
I am trying to LEFT JOIN multiple tables, two tables are data tables and one is a junction (association) table:
[sql]SELECTFROM aquarius.rpi_procedure_sequences INNER JOIN aquarius.rpi_procedures ON (rpi_procedure_sequences.id_procedure = rpi_procedures.id_primary) INNER JOIN aquarius.rpi_sequences ON (rpi_procedure_sequences.id_sequence = rpi_sequences.id_primary);[/sql]
Am I missing an AND or what? I am getting an error in my MySQLYog control panel...
Cheers,
Alex
[sql]SELECTFROM aquarius.rpi_procedure_sequences INNER JOIN aquarius.rpi_procedures ON (rpi_procedure_sequences.id_procedure = rpi_procedures.id_primary) INNER JOIN aquarius.rpi_sequences ON (rpi_procedure_sequences.id_sequence = rpi_sequences.id_primary);[/sql]
Am I missing an AND or what? I am getting an error in my MySQLYog control panel...
Just curious...You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM
aquarius.rpi_procedure_sequences
INNER JOIN aquarius.rpi_procedur' at line 2
Cheers,
Alex