how many types of joins are there in mysql or sql

mysql sql join left-join right-join
PSR picture PSR · Mar 13, 2013 · Viewed 19.8k times · Source

I've heard there are 3 types of joins

I'm not sure of the exact names. Googling has turned up a variety of terms like :

Cross join , left join , right join , inner join , outer join, self join....

Could anyone tell me how many joins exist in MySQL all in all.

Answer

Sandy picture Sandy · Mar 13, 2013

The joins are

1. Inner Join or Equi join
2. Self Join
2. Outer Join
   outer join is again classified into
   a) Left Outer Join
   b) Right Outer Join
   c) Full Outer Join
3. Cross join

Related questions

SQL LEFT-JOIN on 2 fields for MySQL

I have a view A and a view B. In A I have a lot of information about some systems, like IP and port which I want to preserve all. In B I have just one information that I want …

Read More
MySQL select rows where left join is null

I have these MySQL tables: table1: id | writer 1 | Bob 2 | Marley 3 | Michael table2: user_one | user_two 1 | 2 And this query: SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id = table2.user_one This query will return all rows of …

Read More
How to use aliases with MySQL LEFT JOIN

My original query is doing joins using the WHERE clause rather than JOIN. I realized that this was not returning movies that did not have any stars or genres did not show up so I think I have to do …

Read More