Questions tagged as 'join'

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

"ORA-01417: a table may be extra joined to at most one other table"

I'm setting a select and I came across the following error:    ORA-01417: a table may be extra joined to most other table SELECT A.SEQPESSOA, A.NUMERONF, A.NROEMPRESA, A.SEQPRODUTO, D.SEQCONTRATO, E.PERCDESCONTO, D.SEQCONTRATO, E.SE...
asked by 26.06.2017 / 23:17
0
answers

How to relate these tables, returning specific values?

[Firebird] sgbd - IBExpert I need to know how I can relate these two tables (comment below), so that I get the following results: TABLE: CONTARECEBER DTDOCUMENTO (date you entered the system) DTVENCIMENTO (date the document will...
asked by 01.06.2017 / 15:54
2
answers

Select with two columns returning empty

In a mobile application (Android), I have two tables. One login table (user and password) and one of (simple register). The APP has a registry screen, if the user does not have the account it creates at the moment and proceeds. If this user make...
asked by 17.05.2017 / 23:50
2
answers

Group in mysql along with join

I have a student table and a parent table. A student may be associated with up to three parents. SELECT a.idAluno, a.matriculaAluno, a.nomeAluno, a.sexoAluno, a.dataNascAluno, b.id, b.matricula,...
asked by 20.04.2017 / 22:06
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

Using a join to join two tables

I would like to know if it is possible and indicative to use a join to "join" values contained in two tables made in a SQL Server database. I created two tables and one of them has general information for one client and the...
asked by 16.03.2017 / 04:25
1
answer

Select JOIN + AVG () - Doubt with return

I'm solving an exercise but I'm having problems with the return: Question: Write the query that returns the vendor code, the vendor name, the number of products per vendor, and the average price for each vendor, only for vendors that have a...
asked by 10.03.2018 / 13:19
1
answer

Merge results from two tables

I need to make a SELECT into two tables and merge the results. My tables are "class_tracks" and "progress_tracks". In the table "courses_aula" I have all the classes of a course. In the table "cursos_progresso" I have registration only...
asked by 14.12.2016 / 18:47