left join , right join , full outer join , inner join

 

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