Questions tagged as 'inner'

Tagged questions
1
answer

Adding records with type_type in another table

I have 2 tables linked by id and I need to add a field in table 2 by grouping through a field in table 1 -----TABELA 1----- ID_tab1 - tipo_pgto -----TABELA 2----- ID_tab2 - ID_tab1 - valor_pago I want you to show me the sum of the amount p...
asked by 17.11.2015 / 05:18
2
answers

mysql_num_row with inner join

I have 2 tables: Leads Stores The relationship is as follows: 1 shop - > N leads I need to list the number of leads registered for each store and then sort by descending order to know which store has the most leads The i...
asked by 26.04.2018 / 00:57
2
answers

INNER 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 produtos_values.id = produtos_valuedata.valueid,ag...
asked by 12.07.2017 / 16:36
3
answers

Change 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> </tr> </table> Using jquery I can ge...
asked by 24.10.2016 / 00:47
3
answers

How can I display data using JOIN?

I am making a section on my site called "My Ideal Surfboard", in it the user inserts his data (weight, height, etc), a comparison is done in the database ( join ) and is returned to the user type of the ideal board according to his profile...
asked by 15.06.2016 / 19:45
1
answer

Category query in MySQL

I'm learning MySQL, I need a help, I need to make a query that returns me a sales list by product category. ++++++++++++++++++++++++++++++++++++++++++++++ tb categoria campos: (id, categoria) dados: (12, camisas) ++++++++++++++++++++++++++++...
asked by 09.06.2016 / 23:35
3
answers

Relationship of tables

Good Night, I have a database with several tables and I need to do a query relationship 4 tables CREATE TABLE IF NOT EXISTS 'cad_cliente' ( 'id_cliente' smallint(5) unsigned NOT NULL, 'nome_cliente' varchar(45) NOT NULL, 'nom...
asked by 06.07.2015 / 23:00
1
answer

How 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 }}</td>...
asked by 11.12.2017 / 03:20
1
answer

INNER JOIN WITH WHERE MYSQL

I have a foreach that runs each product, then I would like to do a query on two tables from that ID, but I'm not getting it, what am I doing wrong? $collection = Mage::getModel('catalog/product')->getCollection(); foreach ($collection as $k...
asked by 23.11.2017 / 17:56
2
answers

Inner join join table with several equal IDs

The problem is as follows, I have two tables one of contracts and one of borrowers 1xN and when I do inner join it repeats exactly the amount of columns that I have in borrower but only brings the name of the first one. follows an example...
asked by 14.10.2015 / 21:32