I am using laravel 5. And I want to get data by joining 3 tables, but I've got an error like this:
QueryException in Connection.php line 624: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user.id_divisi' in 'on clause' (SQL: select
username,fullname,divisi,rolefromusersinner joindivisionuser.id_divisi=divisi.id_divisiinner joinroleonuser.id_role=role.id_rolewheredeleted_user= 0 order byfullnameasc)
$users = new User();
$user = $users->join('divisi', 'user.id_divisi', '=', 'divisi.id_divisi')
->join('role', 'user.id_role', '=', 'role.id_role')
->select('username',
'fullname',
'email',
'divisi',
'role')
->where('deleted_user', '=', '0')
->orderBy('fullname', 'asc')
->get();
from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/1TePe7r
via IFTTT
Aucun commentaire:
Enregistrer un commentaire