What's are the types of JOINS will support in Mysql?Is there any possible way to do this?

Question

• How to do full joins in mysql? and what are the types of joins will support in mysql.

• Im a begginer in mysql please help me solve this issue.

  Thank you!

Answer 1

Before asking this question, I am assuming that you have not searched the net for anything at all, let alone MySQL documentation. Because I have asked stupid questions in the past (without researching enough), I am going to answer this one. By the way, this is a habit you must work upon. You should search for material, read and try solutions to your problems before coming to Stack Exchange.

Here's a snapshot from Official MySQL Documentation:

Apart from this, here are a few links that would help you understand JOINs, in general:

1. Coding Horror's Visual Explanation of JOINs
2. Stack Overflow - SQL JOINs and their types
3. One of the most popular posts on Stack Overflow - Difference between Inner and Outer JOINs

I think this would suffice for the basic knowledge of JOINs. You'd have to read more about what JOIN to use when - based on the data you want to fetch and also how your database management system (in this case, MySQL) works with JOINs internally to optimize performance.