vipzeus
Member
I have a calc element in my form where i want to call e value from other table.
offerte.spese_gestione_per_mese is a field
simulatore.offerte is a DBJoin where value is ID and Label is nome_commerciale from table offerte
I think i have to create a subquery for simulatore.offerte but i dont't remeber how to do
PHP:
$myDb = FabrikWorker::getDbo(false, 2);
$query = $myDb->getQuery(true);
$query->clear()
->select('(offerte.spese_gestione_per_mese)')
->from($myDb->quoteName('offerte'))
->where($myDb->quoteName('offerte.id') . ' = ' . $myDb->quote('simulatore.offerte'));
$myDb->setQuery($query);
$ccv = $myDb->loadResult();
return $ccv;
offerte.spese_gestione_per_mese is a field
simulatore.offerte is a DBJoin where value is ID and Label is nome_commerciale from table offerte
I think i have to create a subquery for simulatore.offerte but i dont't remeber how to do
Last edited: