inner join

[AlexNV]

select a.campo1, b.campo1 from a inner join b on a.campox = b.campoy