Relacje w MySQL – RIGHT JOIN

SELECT <kolumny> FROM TabelaA A
    RIGHT JOIN TabelaB B ON A.Key = B.Key