MySQL Joins
Syntax
-
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.
