what are the types of join statement in mysql?
['MySQL INNER JOIN (or sometimes called simple join)', 'MySQL LEFT OUTER JOIN (or sometimes called LEFT JOIN)', 'MySQL RIGHT OUTER JOIN (or sometimes called RIGHT JOIN)']