Differences between inner join, left JOIN, right join, outer join in SQL

Differences between inner join, left JOIN, right join, outer join in SQL

For example, you'll know!

Table A (A1,B1,C1) b (A2,B2)

A1 B1 C1 A2 B2

01 Mathematics 95 01 Sheets Three

02 Language 90 02 John Doe

English Harry

Select A.*, b.* from A

INNER JOIN B on (A.A1=B.A2)

The result is: www.2cto.com

A1 B1 C1 A2 B2

01 Mathematics 95 01 Sheets Three

02 Language 90 02 John Doe

Select A.*, b.* from A

Left outer join B on (A.A1=B.A2)

The result is:

A1 B1 C1 A2 B2

01 Mathematics 95 01 Sheets Three

02 Language 90 02 John Doe

03 English NULL null

Select A.*, b.* from A

Right outer join B on (A.A1=B.A2)

The result is:

A1 B1 C1 A2 B2

01 Mathematics 95 01 Sheets Three

02 Language 90 02 John Doe

null NULL null 04 Harry

Select a.*,b.* from A

Full outer join B on (A.A1=B.A2)

The result is:

A1 B1 C1 A2 B2

01 Mathematics 95 01 Sheets Three

02 Language 90 02 John Doe

03 English NULL null

null NULL null 04 Harry

Differences between inner join, left JOIN, right join, outer join in SQL