Question: how many types of joins in mysql?
Answer: There are three types of MySQL joins: 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)