SELECT

    champ1,

    ...

FROM

    table1

[LEFT|RIGHT] OUTER JOIN

    table2

ON

    table1.champA = table2.champB