Kant
Member
My apprenticeship in php sql continues and I would be glad about some help.
I need the data as follows:
The data is searched from the element 'vorname' in the list 'benutzer'.
leftjoin vermietung 'fahrzeug_id' to fahrzeug'id'
leftjoin fahrzeug 'beauftragter_id to benutzer 'id'
I need the data as follows:
The data is searched from the element 'vorname' in the list 'benutzer'.
leftjoin vermietung 'fahrzeug_id' to fahrzeug'id'
leftjoin fahrzeug 'beauftragter_id to benutzer 'id'
Code:
$mydb = FabrikWorker::getDbo(false, 3);
$query = $mydb->getQuery(true);
$query->select('a.vorname')
->from('benutzer AS a')
->leftJoin('fahrzeuge as b ON b.beauftragter_id = a.id')
->leftJoin('vermietung as c ON c.fahrzeug_id = b.id')
->where('b.id = ' . $mydb->quote('{vermietung___fahrzeug_id_raw}'));
$mydb->setQuery($myQuery);
return $mydb->loadResult();