SELECT
    champ1,
    ...
FROM
    table1
JOIN
    table2
ON
    table1.champA = table2.champB