Subquery in Calc element

[vipzeus]

I have a calc element in my form where i want to call e value from other table.

$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

 

[lori19]

Hi there!
I'm not sure what you want to do or where the your problem is, but it sounds to me that you my need a JOIN in your query. See "Selecting Records form multiple tables" in https://docs.joomla.org/Selecting_data_using_JDatabase

Kindly,
Lorenz