Sorry, forgot to format it correctly. Here we go (hopefully):

>>What is the difference between a left join, right join and an inner join in a quick summary?
>
>A Left Join gives you all the records in the first table, plus all the data on the second table that can be included in the first.
>The Right Join is the opposite.
>The Inner Join outputs all the data that has an exact match in both tables.
>

>  Table A      Table B
>---+---+---    ---+---
> 1   A   1      1   Q
> 2   B          2   W
> 3   C   2      3   E
> 4   D   3      4   R
> 5   E   1

>
>The results for the different types of Joins would be:
>

> A LJ B    A RJ B   A IJ B
>---+---   ---+---   ---+---
> A   Q     A   Q     A   Q
> B         E   Q     C   W
> C   W     C   W     D   E
> D   E     D   E     E   Q
> E   Q         R
>

>Got it?
>
>HTH.