Quote from joferar333 on July 7, 2023, 3:20 pm

@luishp

When entering a certain page, I need to take the value of certain fields from 3 different tables..
According to what I was able to investigate via chatgpt it would be like this (but I don't know if
I'm doing it right since when I enter the page after executing this statement it only shows me the value
of the "cajero" field

Table 1 is > "operaciones"
Table 2 is > "saldos"
Table 3 is > "nota"

//Select Combinado
$sqlAlias[21]="selectall";
$sqlQuerys[21]="SELECT * FROM operaciones JOIN saldos ON operaciones.cajero = saldos.cajero JOIN nota ON operaciones.cajero = saldos.cajero ";
$sqlMaxUserLevel[21]=-1;

when entering the page I execute

neoPhpExecSql "db1" "selectall" "" ""

But the result I see is only the value of the "cajero" field

Any suggestions?