How to merge 4 tables into one and show text instead of INT - INNER JOIN

Question

Hi, I know it’s kind of like this in the second print and with Inner Jay but I’m not getting it.

I’m using Mysql Workbench and more when I finish this I want to go to C#.

I have this doubt, I have already joined the 4 tables processos tarefas tipos tecnicos on the table registos.

Primary key equals foreign key, primary key processos = id_processos, the primary key to tarefas = id_tarefas , the primary key to tipos = id_tipos and the primary key of tecnicos = id_tec. The primary key of registos = id_registos.

Now need help to put the value of the 4 tables in text instead of Int.

NOTE: If you need more information!

It’s something like the 2nd Print!

Prints:

Answer 1

You just need to enter the description of the referent table, so instead p.id_processo you do p.descricao_processo

select p.descricao_processo
      ,t.descricao_tipo
      ,[...]
  from      processos p 
 inner join registros r on r.id_processos = r.id_registro
 inner join tipos     t on t.id_registro  = t.id_tipo

Edited

It would be +/- this here, now change the name of the fields according to the fields of your table and also put the fields correctly in the joins if you need...

select r.id
      ,r.descricao_registro
      ,p.id
      ,p.descricao_processo
      ,t.id
      ,t.descricao_tipo
      ,ta.id
      ,ta.descricao_tarefa
      ,te.id
      ,t.nome_tecnico
  from      registros r 
 inner join processos p  on p.id_processos = r.id_processo
 inner join tipos     t  on t.id_tipo      = r.id_tipo
 inner join tarefas   ta on ta.id_tarefa   = r.id_tarefa
 inner join tecnicos  te on te.id_tec      = r.id_tec

Answer 2

I didn’t quite understand your question, but to show the relationship between the different 4 tables use the following syntax:

SELECT (tabela1.campo1, tabela2.campo2, ...)
FROM tabela1
INNER JOIN tabela2 on table1.campoRelação= table2.campoRelação
INNER JOIN tabela3 on table2.campoRelação= table3.campoRelação
INNER JOIN tabela4 on table3.campoRelação= table4.campoRelação

Note: If you select the ID fields you will display the numbers, if you want to display the text you should select a field with the text content.

I hope I’ve helped.