Return to Revisions

If you have 2 tables like below:

Table1    A1    B1          Table2      B2     C2 
          -     -                       -     -
          1     2                       1     1
          2     4                       2     4
          3     5                       5     2

If you use Inner Join you get:

 A1     B1     B2      C2  
 -      -      -       -
 1      2      2       4
 3      5      5       2

If you use Full Outer Join you get:

 A1     B1     B2      C2  
 -      -      -       -
 1      2      2       4
 3      5      5       2
 2      4    NULL     NULL
NULL   NULL    1       1

If you use Left Outer Join you get:

 A1     B1     B2      C2  
 -      -      -       -
 1      2      2       4
 3      5      5       2
 2      4    NULL     NULL