Joins:
*000Joins
000Joins
suggest changeSyntax
INNERandOUTERare ignored.FULLis not implemented in MySQL.- “commajoin” (
FROM a,b WHERE a.x=b.y) is frowned on; useFROM a JOIN b ON a.x=b.yinstead. - FROM a JOIN b ON a.x=b.y includes rows that match in both tables.
- FROM a LEFT JOIN b ON a.x=b.y includes all rows from
a, plus matching data fromb, orNULLsif there is no matching row.
Found a mistake? Have a question or improvement idea?
Let me know.