Code Forums - View Single Post

DJMaze · 06-01-2007, 12:50 AM

"inner join" only show results from both tables if all conditions are met.
So if apples or bannanas has failed a condition there is no result for the record at all.
It's like: SELECT * FROM apples, bannanas

"right join" is the other way round of left join. First find the bannanas and then match an apple

06-01-2007, 12:50 AM	#4 (permalink)
DJMaze Senior Contributor Join Date: Mar 2005 Posts: 651	"inner join" only show results from both tables if all conditions are met. So if apples or bannanas has failed a condition there is no result for the record at all. It's like: SELECT * FROM apples, bannanas "right join" is the other way round of left join. First find the bannanas and then match an apple __________________ UT: Ultra-kill... God like!