select t1.pole1, t1.pole2, t1.pole3, t2.nazov
from tabulka1 t1
inner join tabulka2 t2
on t1.id = t2.id_t2
myslis klasicky inner join dvoch tabuliek? alebo to skus popisat trochu zrozumitelnejsie - tvoj popis je s prepacenim trochu po madarsky.
select t1.pole1, t1.pole2, t1.pole3, t2.nazov
from tabulka1 t1
inner join tabulka2 t2
on t1.id = t2.id_t2