Posts by Arthur Menezes • 26 points
1 post
-
1
votes1
answer46
viewsA: Doubt how to recover data from another table with Postgres
Select t.ramal from Telefone t join Departamento d on d.id = t.id_departamento where d.id = {id que vc quer} Obs: since id_department is a Foreign key I would change the name to fk_departamento…