Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

SankalpRanade's avatar

Write Query using Eloquent

How do i Write following query using laravel's eloquent?

SELECT v.*,s.service_name from service_list s , vendors v where v.service_id = s.id and v.account_status=2;

0 likes
6 replies
shaikh709's avatar
Level 15

I think you wanna join two table. I think this would work.

DB::TABLE('service_list AS s')->select(DB::RAW('v.*, s.service_name'))
                        ->join('vendors AS v', 'v.service_id', '=', 's.id')
    ->where('v.account_status', 2)->get();

Read this part (https://laravel.com/docs/5.4/queries#raw-expressions) of laravel doc. May help in more depth.

SankalpRanade's avatar

@martinbean i am newbie to laravel, and trying to join two tables where vendors table contains foreign key service id reference to other table services which has pk and service name, i wanna get all vendors details along with service name.

I spent time in learning laravel query builder, only thing i didn't get is it's join mechanism..

Please or to participate in this conversation.