How to Laravel Mysql fetch data from database using multiple table join

Question

This is my data retrieving query:

$admin_students=DB::select("select students.*,application_record.*,gender_record.*,
application_record.id as app_primary_id,application_record.status as app_status from students 
left join application_record on application_record.student_id=students.id 
left join application_record on application_record.gender_record_id=gender_record.name");

Table structure

Table 1 = application_record - > id, name, status, gender_record_id, .... 

Table 2 = gender_record - > id, name

Now how can I return the Gender Name using the Gender Record ID which is the primary key for "Table 2"?

Dip Ghosh · Accepted Answer · 2022-03-07 10:53:55Z

2

   DB:: table('students')
    ->leftjoin('application_record, 'students.id','=' , 'application_record.student_id' )
    ->leftjoin('gender_record','application_record.gender_record_id','=','gender_record.id')->select('students.*',' application_record.*,
    'gender_record.*,)->get();

answered Mar 7, 2022 at 10:53

Dip Ghosh

5852 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

How to Laravel Mysql fetch data from database using multiple table join

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