Laravel How to query db with multiple table?

Question

I have a query in mySQL, but i have no idea how to transfer the format to the laravel. This is my query line.

select T.id,t_id,T.name t_name, T.phone t_phone, 
T.address t_address, T.Department t_department,
 bgroup,sgroup,st_id,users.name st_name,
 user_info.phone st_phone, user_info.address st_address,
 user_info.Department st_department,st_hospital,st_code,
 st_art,g_semester from 
 (SELECT user_group.id, t_id, name, phone, address,
 Department, bgroup,sgroup,st_id,st_hospital,st_code,
 st_art,g_semester FROM `user_group` 
 left join user_info on `t_id`  = `school_id`
 left join users on `t_id` =`s_id`) T 
 left join user_info on `st_id`  = `school_id` 
 left join users on `st_id` =`s_id`

Have anyone can help me? How to transfer this query to the laravel format? I dont have any idea how to select from another query?

from (SELECT user_group.id, t_id, name, phone, address, Department, bgroup,sgroup,st_id,st_hospital,st_code, st_art,g_semester FROM user_group left join user_info on t_id = school_id left join users on t_id =s_id) T

What have you tried so far?

Jonas Staudenmeir
– Jonas Staudenmeir

2018-04-19 01:07:38 +00:00
Commented Apr 19, 2018 at 1:07 — Jonas Staudenmeir
– Jonas Staudenmeir, Commented Apr 19, 2018 at 1:07

Jonas Staudenmeir · Accepted Answer · 2018-04-19 01:26:03Z

1

Here's the foundation:

$from = DB::table('user_group')
    ->select('user_group.id', ...)
    ->leftJoin('user_info', 't_id', 'school_id')
    ->leftJoin(...);
DB::query()
    ->select('T.id as t_id', ...)
    ->fromSub($from, 'T')
    ->leftJoin('user_info', 'st_id', 'school_id')
    ->leftJoin(...)
    ->get();

answered Apr 19, 2018 at 1:26

Jonas Staudenmeir

26k7 gold badges70 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel How to query db with multiple table?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related