What is CROSS, STRAIGHT_JOIN, NATURAL, OUTER join in Mysql?

joined_table:
table_reference {[INNER | CROSS] JOIN | STRAIGHT_JOIN} table_factor [join_specification]
| table_reference {LEFT|RIGHT} [OUTER] JOIN table_reference join_specification
| table_reference NATURAL [INNER | {LEFT|RIGHT} [OUTER]] JOIN table_factor

Deal with join in Mysql, everywhere I read mostly about INNER, LEFT JOIN, RIGHT JOIN, and what
CROSS, STRAIGHT_JOIN, NATURAL, OUTER join in Mysql ?
April 7th 20 at 10:40
1 answer
April 7th 20 at 10:42
here again, only INNER and LEFT JOIN - Cassandre.Sanford92 commented on April 7th 20 at 10:45

Find more questions by tags MySQL