Adding a Third Table to a Two-Table Join Query
- by John
Hello,
The query below works just fine. It pulls fields from two MySQL tables, "comment" and "login". It does this for rows where "username" in the table "login" equals the variable "$profile." It also pulls fields for rows where "loginid" in the table "comment" equals the "loginid" that is also being pulled from "login."
I would like to pull data from a third table called "submission," which has the following fields:
submissionid loginid title url displayurl datesubmitted
I would like to pull fields from rows in "submission" where "loginid" equals the "loginid" that is already being pulled from the other two tables, "login" and "comment."
How can I do this?
Thanks in advance,
John
Query:
$sqlStrc = "SELECT l.username, l.loginid, c.loginid, c.commentid, c.submissionid, c.comment, c.datecommented
FROM comment AS c
INNER JOIN login AS l
ON c.loginid = l.loginid
WHERE l.username = '$profile'
ORDER BY c.datecommented DESC
LIMIT 10";
