Convert sql join query to laravel

Question

SELECT school_courses.*, schools.school_name, schools.country, schools.city  FROM 
school_courses JOIN schools ON school_courses.school_id = schools.id

Hello there,

I want to convert the above SQL query to laravel. And also I want to learn joins in laravel query please share any easy step by step tutorial link if you have one.

If you really want to learn how to do this, then the best thing would be to attempt to write a solution in Laravel and then include that in your question. As for tutorial sites, the official documentation already does a good job of explaining joins. — Tim Biegeleisen
– Tim Biegeleisen, Commented Dec 28, 2020 at 7:21

Prashant Deshmukh..... · Accepted Answer · 2020-12-28 07:25:51Z

1

This is Query Builder way of doing it.

   $result = DB::table('school_courses')
         ->join('schools','schools.id','=','school_courses.school_id')
         ->select('school_courses.*','schools.school_name', 'schools.country', 'schools.city')
         ->get();

Refer this link https://laravel.com/docs/8.x/queries#joins

answered Dec 28, 2020 at 7:25

Prashant Deshmukh.....

2,2921 gold badge11 silver badges11 bronze badges

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

1 Comment

JIGNESH PATEL Over a year ago

Thank you! for your quick response. I will refer to this link.

A.A Noman · Accepted Answer · 2020-12-28 07:31:32Z

1

My suggestion is to use better Eloquent: Relationships

Relationships

Your converted query is given below

use Illuminate\Support\Facades\DB;

$users = DB::table('school_courses')
         ->join('schools', 'us schools ers.id', '=', 'contacts.user_id')
         ->select('school_courses.*','schools.school_name', 'schools.country', 'schools.city')
         ->get();

answered Dec 28, 2020 at 7:31

A.A Noman

5,2669 gold badges28 silver badges49 bronze badges

Collectives™ on Stack Overflow

Convert sql join query to laravel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related