Hi all,
I am new to innner joins and i am having trouble with the one i have, would really appreciate any help given.
Original Query
$query = "SELECT *
FROM jobcard_index AS a, jobcard_detail AS b, jobcard_description AS c
WHERE c.detail_id = b.detail_id
AND c.page_number = b.page_number
AND b.jobcard_id = a.jobcard_id
AND a.jobcard_id = '$jobcard_id'";
Inner Join
$query = "SELECT *
FROM jobcard_index AS a
INNER JOIN jobcard_detail AS b
(INNER JOIN jobcard_description as c
ON b.page_number = c.page_number)
ON b.jobcard_id = a.jobcard_id
WHERE a.jobcard_id = '$jobcard_id'";
I keep getting the following error
You have an error in your SQL syntax near '(INNER JOIN jobcard_description as c ON b.page_number = c.page_number) INNER JO' at line 4
Thanks in advance for any help, advice given.
Regards,
Steven
