Chapter 2: SQL multi-table join

Multi-table join relationships of SQL are: inner join, outer join, and cross join.

Create two tables for Demonstration:

TB_Characters:

Id	Character
1	Introverted
2	Extrovert
3	Neutral character

TB_Colors:

Id	Color
1	Green
2	Red
4	Blue

1. Internal Connection:

JOIN or inner join: returns the intersection of inner join.

:

Tb_characters tb_colors tb_characters.ID tb_colors.ID;

Result:

Tb_characters tb_colors tb_characters.ID tb_colors.ID;

Result:

Tb_characters tb_colors tb_characters.ID tb_colors.ID;

Result:

Tb_characters tb_colors tb_characters.ID tb_characters tb_colors tb_characters.IDtb_colors.ID

Result:

Tb_characters tb_colors;

Result:

Tb_characters, tb_colors tb_characters.ID tb_colors.ID;

2. Obtain the cross-join result as follows:

   tb_characters,tb_colors;