Select with 3 tables in SQL SERVER

Question

I need to make a select in the machine table, but when I run my command

select maq.maqNip, equi.* from tblMaquina maq
join tblEquipamento equi on equi.equId = maq.maqTipoEqui;

the following result comes out and I wanted the brand name to appear, the model and not just your ID.

Could someone help me link these three tables?

Answer 1

Just add one more INNER JOIN with the other table of Marca:

SELECT * 
  FROM tblMaquina maq
 INNER JOIN tblEquipamento equi 
    ON equi.equId = maq.maqTipoEqui;
 INNER JOIN tblMarca marca
    ON equi.marcaId = marca.marcaId;

Observing: Don’t forget to change table and field names to match your template. I did this as an example, because I do not have the names of their fields.

Answer 2

Try to do so:

select maq.maqNip, equi.*, marc.* from tblMaquina maq
inner join tblEquipamento equi on equi.equId = maq.maqTipoEqui
inner join tblMarca marc on marc.marcId = equi.equMarca

Answer 3

Try to run the following query

select 
   maq.Nip, 
   equip.tipo, 
   marc.nome 
from 
   Maquina maq,
   Marca marc,
   Equipamento equip,
where
   maq.tipo = equip.id
and
   equip.marca = marc.id;

Answer 4

Also includes a (NOLOCK) not to allocate the tables in processing time

SELECT * 
  FROM tblMaquina (NOLOCK) maq
 INNER JOIN tblEquipamento (NOLOCK) equi 
    ON equi.equId = maq.maqTipoEqui;
 INNER JOIN tblMarca (NOLOCK) marca 
    ON equi.marcaId = marca.marcaId;