MySQL

JOIN TYPE

[INNER | CROSS] JOIN
STRAIGHT_JOIN
{LEFT|RIGHT} [OUTER] JOIN
NATURAL [{LEFT|RIGHT} [OUTER]] JOIN

Integer Types
SQL standard		SMALLINT		INTEGER／INT
MySQL	TINYINT	SMALLINT	MEDIUMINT	INT	BIGINT