Most voted "inner" questions
52 questions
Sort by count of
-
6
votes2
answers985
viewsHow to make an INNER JOIN not repeat information
I got the following SQL INNER JOIN: $sqlxml = " SELECT clientes.id, clientes.nome, clientes.status, clientes.cliente, clientes.tipo, clientes.disponibilidade, imoveis.id, imoveis.cod,…
-
6
votes2
answers361
viewsCount friends in common using LEFT JOIN
I have the following tables: users: id | usuario | pnome | snome | foto 1 | Igor | Igor | Souza | perfil.png 2 | Alex | Alex | Khal | foto.jpg 3 | Maria | Maria | Silva | foto.png friendships: id |…
-
5
votes2
answers1093
viewsDelete data from cascading table
I have some relationships on my tables and I’m willing to delete inversely. on my system the user will have the option to delete a category, here comes my question as I will do this because it…
-
4
votes2
answers179
viewsDoubt about using the Inner Join
I have 4 tables in my database Tabela Cadastro - idCadastro(PK) - IP Tabela Porta - idPorta(PK) - numero porta - idSwitch(FK) Tabela Porta_has_Cadastro - idCadastro(FK) - idPorta(PK) //Observação:…
-
3
votes1
answer10458
viewsHow to use Inner Join in Laravel 5?
I have the following loop in a view table @foreach ($filme as $f) <tr> <td>{{ $f->fil_id }}</td> <td>{{ $f->fil_filme }}</td> <td>{{ $f->fil_sinopse…
-
3
votes3
answers97
viewsRelationship between the 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 | | 0856322 | 8 | 128 | | 0856322 |…
-
2
votes1
answer400
viewsAdd records with type
I have 2 tables linked by id and need to add a field in table 2 grouping through a field in table 1 -----TABELA 1----- ID_tab1 - tipo_pgto -----TABELA 2----- ID_tab2 - ID_tab1 - valor_pago I want…
-
2
votes2
answers1684
viewsSelect with INNER JOIN, bringing fields that have NULL foreign key
I have a table items, requested items, interested (she has self relationship, is used for secretariat, sector and employee, and a table requested), in the table requested I have 3 foreign keys (one…
-
2
votes1
answer1411
viewsSelect with Inner June too slow
I have a problem where select is bringing the right result, but taking too long. Follow select : SELECT c.cod_paciente, p.nome, i.valor, i.quantidade, d.convenio, c.cod_conta FROM caddadosclinico d…
-
2
votes1
answer192
viewsMYSQL - Select 2 tables
Good morning Personal! I have a problem when performing a query in MYSQL, and the query I am using is not displaying the desired results. Follow the example: TABLE: CLIENTES (codigo_cliente, nome,…
-
2
votes1
answer864
viewsUsing data from one select within another?
Two tables tbl_orcamento and tbl_itens the budget table has a column with the following status. 1 = orcamento aprovado 2 = ordem de compra emitida 3 = ordem de compra aprovada To tbl_itens has some…
-
2
votes1
answer268
viewsC# Webbrowser How can I get innerHTML from a span within a div
HI GUYS. I need to get c# the innerHTML of the first SPAN element that has a value with numbers that is inside a div and I I’ve even written a code that’s on the right track, I think. So far this is…
-
1
votes3
answers300
viewsRelationship of tables
Good Night, I have a database with several tables and need to make a query relationship 4 tables CREATE TABLE IF NOT EXISTS `cad_cliente` ( `id_cliente` smallint(5) unsigned NOT NULL, `nome_cliente`…
-
1
votes2
answers1283
viewsInner Join table with multiple identical Ids
The problem is this, I have two tables one of contracts and another of 1xN borrowers and when I do the inner join it repeats exactly the amount of columns I have in borrower but only bears the name…
-
1
votes3
answers132
viewsExchange td value after validation
I have the following HTML code <table> <tr> <td class="x">10</td> <td class="x">10</td> <td class="x">12</td> <td class="x">18</td>…
-
1
votes0
answers82
views -
1
votes1
answer139
viewsCategory query in Mysql
I’m learning Mysql, I need help, I need to perform a query that returns a sales list by product category. ++++++++++++++++++++++++++++++++++++++++++++++ tb categoria campos: (id, categoria) dados:…
-
1
votes1
answer326
views -
1
votes2
answers908
viewsINNER JOIN in the same table
SELECT Agendamento.E3TimeStamp AS Data,Agendamento.Lote, Produtos_values.name as NomeProduto, Produtos_ValueData.TemplateID AS mp_produto FROM produtos_values inner join produtos_valuedata on…
-
1
votes2
answers60
viewsmysql_num_row with Inner Join
I have 2 tables: Leads Shops The relationship is as follows: 1 store -> N leads I need to list the number of registered leads for each store and then sort in descending order to know which store…
-
1
votes3
answers1607
viewsHow can I view data using JOIN?
I am making a section on my site called "My Ideal Board", in it the user inserts his data (weight, height, etc), a comparison is made in the bank (join) and is returned to the user the ideal board…
-
1
votes1
answer561
viewsMysql SELECT with JOIN and LIMIT in child table
I have a table catalogo related to another table imagens. Each record in catalogo has N images. I need that in a SELECT with INNER JOIN imagens, only 3 images are returned for each table row…
-
1
votes1
answer40
viewsHow to catch the latest releases of an Inner Join
Staff to making a query in 3 tables with Internet, follow the code: select itensVenda.idVenda, itensVenda.idProd, itensVenda.qtd, produtos.id, produtos.descricao, produtos.foto, venda.id,…
-
1
votes2
answers855
viewsUpdate Inner Join (update in two tables) - Php; Mysql
I have two tables and I want to do a Join to update both at the same time. Table1: Clipping (id, dia_semana, data) Table2: imagemClipping( id, id_clipping, titulo, dia_semana, data, imagem)…
-
1
votes1
answer813
viewsINNER JOIN WITH WHERE MYSQL
I have a foreach that runs each product, then I would like to make a query in two tables from that ID, only I’m not getting, what I’m doing wrong? $collection =…
-
1
votes1
answer81
viewsMysql - Inner Join runs on PHPADMIN but not on php SCRIPT
I have a small PHP script to interact with MAKERIOD. When I run select in PHPADMIN I get the return : "Showing 0 - 16 records (total 17, query took 8.0945 seconds.)" SELECT Tbdiario.cn1,…
-
1
votes1
answer31
viewsDoubt about SQL
Good afternoon guys, I am learning SQL and I have to do an exercise that is: Select the first and last names of employees and consultants working in the "Financial" department. Turns out I’m trying…
-
0
votes1
answer27
viewsSelect some data from different tables
Reborn the programmer around here, I’m having trouble with SQL and ask for help. I have two tables called orcamentos and clientes. I need to select all fields in the table orcamentos and only the…
-
0
votes0
answers127
viewsSelect in two fields of a table
Hello, I’m going through a problem and I would like to ask for your help. Here’s the thing: I am integrating a PHP system to the Wordpress Woocommerce plugin and I need to order some products from…
-
0
votes1
answer238
viewsHow to display the result of an Inner Join for the user?
I have three tables and want to join them and display them to the user, how can I do this using the functions of Wordpress? INSERTS THE DATA INTO THE DATABASE: function cadastra_experiencia($nome,…
-
0
votes1
answer159
viewsHow to change the text of a <p> inside php? Can you insert a snippet in Javascript?
I am making a registration that cannot have users with the same name/nick registered. To validate whether or not PHP is used, I would like to know how to print a p with a message on the screen if…
-
0
votes2
answers120
viewsInner Join not returning database values
MY BANK CREATE TABLE EXPERIENCIA( exp_pri INT NOT NULL AUTO_INCREMENT, nome VARCHAR(150), email VARCHAR(50), exp VARCHAR(100), PRIMARY KEY(exp_pri) ); CREATE TABLE PRANCHA( prancha_pri INT NOT NULL…
-
0
votes1
answer60
views -
0
votes1
answer2205
viewsSelect using Join with Distinct
I have two tables: tb_movement | cod | dt_producao | qt_prod | |-----|--------------|---------| | 1 | '04.08.2016' | 10 | | 2 | '04.08.2016' | 5 | | 3 | '09.08.2016' | 12 | | 4 | '10.08.2016' | 3 |…
-
0
votes1
answer83
viewsHow to interpret * in this query
I got a query which, apparently, is simple if it weren’t for the fact that I have these two * Alas, I’m not sure if it’s inner join, left join or someone from the same family. I need to turn this…
-
0
votes2
answers798
viewsSum with Internet Oracle
Staff need a help, I need to create a report that shows the total quantity of each product in stock, but I can not make appear the name of the products, only the product code and the sum of the…
-
0
votes1
answer54
viewsI am unable to gather data - must be lack of INNER JOIN
I have two tables, the tab_prefixo has number of prefixo and gerente responsible (important data), and in the other (table tab_valores), also presents the prefixo, plus nome, valor and data. I want…
-
0
votes2
answers740
viewsInner Join mysql 2 tables
Good evening guys, I need to link two tables and I’m not able to correct or find where I’m going wrong. I have two tables: Table 1: br_regiao | id - iduf - name - (1 , 1, Litoral) Table 2: br_estado…
-
0
votes1
answer49
viewsPostgresql Database
How do I select with sum and inner join to sum an x value between 3 tables. A query to return as few results as possible. create table credit_card ( credit_card_id int primary key, nome varchar (30)…
-
0
votes2
answers864
viewsconsult with Internet in codeigniter
Good afternoon, folks, I’d like to ask for your help on something I’ve been racking my brain about and I can’t seem to get it right have 4 tables products ->id | Slug | title | info1 | info2 |…
-
0
votes0
answers630
viewsINNER JOIN with a SELECT TOP
When generating a script, I tried to modify a Where for Inner Join. However, the time when running with Inner Join was more than 10 minutes and with Where, it was in a matter of seconds, as the…
-
0
votes1
answer47
viewsJoin two Mariadb SQL queries
Two tables tab_Ord_Ser and tab_Pos_Alb. In two different queries I can know the values but I’m not able to unite them in just one. Are they: SELECT Prazo_Producao as Data, COUNT( `Numero OS` ) AS…
-
0
votes1
answer105
viewsusing CAST in INNER
Good morning I’m trying to make a mistake but Join. string Query = "Select rec.chvbfj, rec.doc, vndB.chvvnd, vndB.chvps, ps.chvps, ps.Dsc " + "From (( " + "rec " + "inner join vndB " + "on…
-
0
votes2
answers2625
viewsInner Join with two keys with python
I have two tables, one for consultation and one for examinations, both with the date of execution and the code of the beneficiary. Want to make a third table with people who have had exams and…
-
0
votes0
answers49
viewsHow to concatenate results from an SQL
I have two tables: Produtos, Eventos and Productsprovents(coming from the many ratio for many of the tables Products and Events): I performed the following SQL to get the event data and products…
-
0
votes1
answer48
viewsINNER JOIN Horizontal Results
I am sure it is something simple, but I am not succeeding: I will give the example. tb_empresa e tb_contatosdaempresa Each company has up to 8 contacts (Fields: id_company / name / phone / email) I…
-
0
votes1
answer46
views -
0
votes1
answer35
viewsProblem sorting data resulting from Inner Join
Guys, I have a basic question but I’m having a huge difficulty in making an appointment. I have a protocol system in which protocol data is recorded in a table called PROTOCOL and the updates of…
-
0
votes2
answers74
viewsMysql - Catch minor record in a 1:N ratio
Good evening, I may have this answer somewhere but I spent all day researching, using various examples and nothing. I have 2 tables, one of products and another with the models being that 1 product…
-
-1
votes2
answers543
viewsAssign value to SQL variable
How do I make one select which assigns the value "10" in all of the games column? Note: Without giving update on the table. /*minha_tabela*/ codigo jogos --------------------- 1 10 2 10 3 10 4 10 5…