SQL join outer JOIN INNER JOIN full join cross Join

Joins are divided into:

INNER JOIN???????????????????????? [INNER JOIN]

Outer JOIN???????? (left outer join, right outer join)???????? [Left Join/left outer joins, right join/right outer JOIN]

Full Join???????????????????? [Full JOIN]

Cross Join???????????????????? [Cross Join]

Table A???? Id???? Ebcid???? Name???????? Table B???? Uid???? Ebcid

???? 1???? 1???? Aa???????????? 1???? 1

???? 2???? 2???? Bb???????????? 1???? 2

???? 3???? 3???? Cc???????????? 1???? 3

???? 4???? 4???? Dd???????????? 2???? 2

???? 5???? 5???? Ee???????????? 2???? 3

Inner joins

Select A.*, b.* from a inner join B on a.ebcid = B.ebcid

Results:

1???? 1???? Aa???? 1???? 1

2???? 2???? Bb???? 1???? 2

3???? 3???? Cc???? 1???? 3

2???? 2???? Bb???? 2???? 2

3???? 3???? Cc???? 2???? 3

?

Left OUTER JOIN

Select A.*, b.* from a LEFT join B on a.ebcid = B.ebcid

1???? 1???? Aa???? 1???? 1

2???? 2???? Bb???? 1???? 2

2???? 2???? Bb???? 2???? 2

3???? 3???? Cc???? 1???? 3

3???? 3???? Cc???? 2???? 3

4???? 4???? Dd

5???? 5???? Ee

?

Right outer join (the right table is the main, example is not typical ~ ~)

Select A.*, b.* from a right join B on a.ebcid = B.ebcid

1???? 1???? Aa???? 1???? 1

2???? 2???? Bb???? 1???? 2

3???? 3???? Cc???? 1???? 3

2???? 2???? Bb???? 2???? 2

3???? 3???? Cc???? 2???? 3

?

Full Join

It's all around.

Cross Join (Cartesian product)

SQL join outer JOIN INNER JOIN full join cross Join