I have taken an example of a people register with the following structure:
I'mtryingtomakeaSELECTintblPessoawithJOINwiththeintentionthatselectreturnsthedataofthetableinwhichtheIdexists,selectselect:selecttblPessoaJuridica.Nomeas[NomePJ],tblPess...
I'm using pthread.h and using the following functions:
//
// Cria A thread
//
thread_argsPP[contthreadsPP] = contthreadsPP;
pthread_create(&threadsPP[contthreadsPP], NULL, ReceivePinPad, (void *) &thread_argsPP[cont...
Hello, I'm new to SQL and am having a question. As in the example below, I wanted to get a description of the code in the 'a' table from a table 'b'. But the number of rows in table 'a' when I do this increases significantly.
select a.banana,...
I need to perform a SQL query in PHP, where I need to create a table from other 9 tables, joining all the columns with a LEFT JOIN, and with the 'Client' field as the key between the tables. However, in each table there is more than one record o...
I have two tables:
Users:
id | nome | email
submissions:
id | id_envia | id_recebe
Every time a user sends a card (which goes by email) to another user, it marks this table, and every time it receives a tag as well.
Doubt:
I...
I have the following DB:
WhenIrunthefollowingQuery:SELECTtbCelula.*FROM(((tbTiposMonitorizacaoINNERJOINtbMonitorizacaoProjONtbTiposMonitorizacao.TM_ID=tbMonitorizacaoProj.MP_T_ID)INNERJOINtbListaConformidadesONtbMonitorizacaoProj.MP_ID=tbListaC...
I would like to know how to do a Select to return non-existent records by comparing two tables with the String field.
Example:
Tabelas Campo1 Campo2
Tab1 Nome Tel
Tab2 Nome email
The result of the comparison (the select)...
I'm trying to do a SELECT with multiple tables, where I have a product with your information, and I have another table structure to be able to add an extra field and their respective information.
What I tried to do was this:
SELECT p.codigo...
Folks, I need somebody's help to understand the mistake you're making.
I have two tables as shown in the code, and in one of the tables the "CodePlane" column has information.
I need to put the codes related to the Beneficiaries.
But it is giv...
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...