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...
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...
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...
[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...
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...
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,...
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...
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...
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...
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...