I need to work out a query that brings the employee's registration, employee's name, and employee's city name using JOIN
. But as I have no experience yet with this function, I'm stuck !! For this I have the funcionario
table and the cidade
table. So far I have this:
select * from funcionario, cidade
select funcionario.matfunc, funcionario.nome, cidade.nome
from funcionario, cidade
where funcionario.nome = cidade.nome
Now I'm stuck because I did not get the JOIN
bid.