Archive for October, 2008

01
Oct

mysql double join

 

 

SELECT  hobbies.id,membershobbies.hobbyid
FROM hobbies LEFT JOIN membershobbies on membershobbies.hobbyID=hobbies.id RIGHT JOIN members ON members.id = membershobbies.memberid
WHERE members.id=1