No need say any more , just see the examples.
Table A , Table B
id name id books
1 binny 1 aaa
2 liangbinny 2 bbb
3 wenbin 4 ccc
left join
SELECT * FROM A INNER JOIN B ON A.ID=B.ID
1 binny 1 aaa
2 liangbinny 2 bbb
3 wenbin null null
this depands on table A, just say, Table A records will all show , and table B record will show only if match the where codintional.
right join
SELECT * FROM A RIGHT JOIN B ON A.ID=B.ID
1 binny 1 aaa
2 liangbinny 2 bbb
null null 4 ccc
this depands on table B, just say, Table B records will all show , and table A record will show only if match the where codintional.
full outer join
SELECT * FROM A FULL OUTER JOIN B ON A.ID=B.ID
1 binny 1 aaa
2 liangbinny 2 bbb
3 wenbin null null
null null 4 ccc
this depands on table A and B, just say, Table A and B records will all show .
inner join
SELECT * FROM A INNER JOIN B ON A.ID=B.ID
1 binny 1 aaa
2 liangbinny 2 bbb
it will only show the records which A.ID=B.ID