Try joining parents to parentlog by left using(parent_id) . If you receive 1 row for
student that has 2 parents (I say this because
I've never been in such situation) try to join but not left - ordinary join. So
select * from students left join parentlog using(student_id) left join parents
select * from parents,parentlog left join students using(student_id) where
Hope this helps.
----- Original Message -----
From: "John Hughes, Jomari Works" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 16, 2002 8:23 AM
Subject: [PHP-DB] Joining three tables
> SQL QUERY question
> I have three tables:
> students has student_id and student_name
> parents has parent_id and parent_name
> parentlog has student_id and parent_id
> I want to search the parentlog WHERE student_id = some_id
> GROUP BY parent_id
> (This will bring back two rows when there are two parents)
> At the same time I want to get the name of the student that
> matches student_id and the name of the parent.
> I can LEFT JOIN students with parentlog USING(student_id) but
> I can't figure how I can join the parents so that I can get
> the name of match for the parent_id.
> Can I join three tables and search all in one pass?
> John Hughes
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php