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