mardi 17 mai 2016

Sql query join 3 tables in laravel?

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, email, divisi, role from users inner join divisi on user.id_divisi = divisi.id_divisi inner join role on user.id_role = role.id_role where deleted_user = 0 order by fullname asc)

$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