Demonic Posted November 6, 2007 Share Posted November 6, 2007 Okay I basically get the idea of OUTTER JOIN ... ON and INNER JOIN ... ON so whats LEFT JOIN and RIGHT JOIN etc.. Quote Link to comment https://forums.phpfreaks.com/topic/76138-joins/ Share on other sites More sharing options...
Barand Posted November 6, 2007 Share Posted November 6, 2007 http://www.w3schools.com/sql/sql_join.asp Quote Link to comment https://forums.phpfreaks.com/topic/76138-joins/#findComment-385358 Share on other sites More sharing options...
teng84 Posted November 6, 2007 Share Posted November 6, 2007 left join returns all the row from the 1st table right is form the other table inner join returns row from the 1ts table that matches the other table Quote Link to comment https://forums.phpfreaks.com/topic/76138-joins/#findComment-385360 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.