SELECT * FROM tabellaA AS o JOIN tabellaB AS c WHERE c.id = o.id