Presto-X Posted August 11, 2011 Share Posted August 11, 2011 Hello everyone, I'm doing a simple query of 3 tables the first is the main table to get a list of upcoming classes, and the other two is to get the course title and the instructor's name, the problem is if an instructor has not been assgned the result does not get returned it just skips that row, I'm guessing it's becuase the instructor's id is 0 not sure? If the courses.id and users.id is set it will get the row, but if ether of them are set to 0 then it skips the row. Can you take a look at my query and see where I'm going wrong, thanks everyone. SELECT classes.id, classes.state, classes.date AS created, classes.city, users.`name` AS instructor, courses.title AS course FROM classes INNER JOIN users ON users.id = classes.instructor_id INNER JOIN courses ON courses.id = classes.courseid Link to comment https://forums.phpfreaks.com/topic/244553-trying-to-query-3-tables-using-inner-join/ Share on other sites More sharing options...
kickstart Posted August 12, 2011 Share Posted August 12, 2011 Hi If you want a row returned when one of the joined tables doesn't have a matching row then use an outer join SELECT classes.id, classes.state, classes.date AS created, classes.city, users.`name` AS instructor, courses.title AS course FROM classes INNER JOIN users ON users.id = classes.instructor_id LEFT OUTER JOIN courses ON courses.id = classes.courseid All the best Keith Link to comment https://forums.phpfreaks.com/topic/244553-trying-to-query-3-tables-using-inner-join/#findComment-1256259 Share on other sites More sharing options...
Presto-X Posted August 12, 2011 Author Share Posted August 12, 2011 Thanks so much Keith, I really need to learn my joins better, thanks again for the help Link to comment https://forums.phpfreaks.com/topic/244553-trying-to-query-3-tables-using-inner-join/#findComment-1256261 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.