Devi usare la clausola JOIN
Esempio:
codice:
SELECT t01.campo01, t02.campo02
FROM tabella01 AS t01
INNER JOIN tabella02 AS t02
ON t01.CODICE = t02.CODICE