Questions tagged as 'inner-join'

Tagged questions
3
answers

Relationship between tables

I have the following tables: TB_ESTOQUE |COD_PRODUTO|QT_DISPONIVEL|COD_FILIAL| | 0856322 | 5 | 41 | | 0856351 | 2 | 41 | | 0856322 | 9 | 114 | | 0856720 | 3 | 20 | | 08563...
asked by 09.10.2018 / 16:41
2
answers

___ ___ erkimt Query SQL unifies three tables ______ qstntxt ___

I have 4 tables that I need to join in a single query where the result is:

%pre%

The tables look like this:

%pre%

I tried to do with INNER JOIN, but I'm still a beginner, and I could not, when I added the conversations went wrong, below what I tried:

%pre%     
______ azszpr313556 ___

You can reach these values as follows:

%pre%

I was giving error because the %code% field was not in %code% . The query would never give the result it expected because it had two %code% to two tables with associations other than the %code% table, and even correcting %code% would not be able to correctly count the occurrences in each of the tables. p>     

______ azszpr313560 ___

If you are using %code% you can do this:

%pre%

Test: link

    
___

I have 4 tables that I need to join in a single query where the result is: nome |COUNT(terrenosDeCadaID)|COUNT(conversasDeCadaID) joao | 2 | 3 maria| 1 | 2 The tables look like this: use...
asked by 11.07.2018 / 15:50
2
answers

Doubt to use Replace along with Inner Join

I'm using Inner Join to combine two tables: SELECT eventos.colab_id, colaboradores.setor FROM colaboradores INNER JOIN eventos ON colaboradores.id = eventos.colab_id So far so good, however I have cases where I need to delete the...
asked by 31.10.2018 / 17:53
1
answer

SQL JOIN multiple tables

I have 4 tables that I need to extract the results, but I always get duplicate records, can anyone help? tabclientes: codcli nome 1 A 2 B 3 C tabrepre: codrepre nome 1 AA 2 AB 3 AC tabvendedor: codr...
asked by 10.07.2018 / 23:00
1
answer

Inner Join with Where and multiple tables

I'm setting up a query, where I need to join between two tables (since the data will be in the main B but not in the BC complement) and a third table that I need the data, which will always be in the main table B. I tried as below, but return...
asked by 05.11.2018 / 20:53
1
answer

INNER JOIN in 4 tables

I have 4 tables: TB_OS_MANUTENCAO: TB_OS_ELETRONICA: TB_OS_MECANICA: ETB_OS_INFORMATICA: As shown in the screenshots, all tables have one field in common, the call_id, and also with a common value, 8. This field is not marked UNIQUE a...
asked by 24.10.2018 / 00:52
1
answer

Sql using left join

I have the following tables: TB_ESTOQUE |PRODUTO|QT_DISPONIVEL|COD_FILIAL| |0856322| 5 | 41 | |0856351| 2 | 41 | |0856322| 9 | 114 | |0856720| 3 | 20 | TB_FILIAL |COD_FILIAL|COD_L...
asked by 08.10.2018 / 21:57
1
answer

Inner Join with like, Mysql, and Datatable

Personally, I have a problem at the time of searching a field in the datatable, I have a taxpayer table, this is linked to taxpayers_param, taxpayers_end and taxpayers_tel. I'm trying to do a search using like and inner join, until then the sear...
asked by 07.08.2018 / 17:48
1
answer

How to get the latest releases from an inner join

Personal to doing a query in 3 tables with inner join, follows the code: select itensVenda.idVenda, itensVenda.idProd, itensVenda.qtd, produtos.id, produtos.descricao, produtos.foto, venda.id, venda.valor from prod...
asked by 30.08.2018 / 22:41
1
answer

How do I make an INNER JOIN with condition?

I have the following SQL that only shows me properties that have a photo registered, as specified in the lines: INNER JOIN fotos ON imoveis.id = fotos.cod How to display properties with or without registered photos? Follow the compl...
asked by 26.07.2018 / 12:21