Questions tagged as 'inner'

Tagged questions
2
answers

Inner join not returning bank 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 AUTO_I...
asked by 14.06.2016 / 16:52
1
answer

How to change the text of a p within php? Can you insert a snippet in JavaScript?

I am making a registration in which can not have users with the same name / nick registered. To validate whether or not I use PHP, I would like to know how to print a p with a message on the screen if a user with that name already exists. I trie...
asked by 14.06.2016 / 04:35
1
answer

Join two SQL queries MariaDB

Two tables tab_Ord_Ser and tab_Pos_Alb . In two different queries I can know the values but I can not unite them in just one. These are: SELECT Prazo_Producao as Data, COUNT( 'Numero OS' ) AS Produzir, Tipo_Album FRO...
asked by 24.04.2018 / 21:18
0
answers

INNER JOIN with a SELECT TOP

While 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 the where, it was in a matter of seconds, as the example below. I would like to know why th...
asked by 24.04.2018 / 15:01
2
answers

consult with inner join in codeigniter

Good afternoon, I would like to request your help in something that I have broken my mind to solve and I can not fix it to work out I have 4 tables products -> id | slug | title | info1 | info2 | info3 prodnutri - > idNutricion | i...
asked by 10.04.2018 / 03:58
1
answer

I can not join data - it must be INNER JOIN

I have two tables, tab_prefixo has number of prefixo and gerente responsible (important data), and in the other one (table tab_valores ), it also displays prefixo , nome , valor and data . I...
asked by 10.08.2017 / 03:46
0
answers

Select in two fields of a table

Hello, I'm having a problem and I'd like to ask for help from you. It is as follows: I'm integrating a PHP system into the Wordpress Woocommerce plugin and I need to order some products from the database, so far so good. The problem starts wh...
asked by 05.07.2017 / 19:43
2
answers

Sum with inner join Oracle

People need help, I need to create a report that shows the total quantity of each product in stock, but I can not get the name of the products, only the product code and the sum of the quantity of the products I have. Here is the code I did: S...
asked by 30.06.2017 / 15:57
1
answer

Mysql SELECT with JOIN and LIMIT in child table

Hello, I would like the help of the collaborators. I have a table "catalog" related to another table 'images'. Each record in "catalog" has n pictures. I need in a SELECT with INNER JOIN images, only 3 images are returned for each row of the cat...
asked by 16.04.2017 / 02:59
1
answer

How to display the result of an Inner Join for the user?

I have three tables and I want to put them together and display them to the user, how can I do this using the WordPress functions? INSERT THE DATA ON THE BANK: function cadastra_experiencia($nome, $email, $experiencia){ //INSERE OS...
asked by 13.06.2016 / 20:14