Write Query using Eloquent

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 What have you tried so far?

@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..

@shaikh709 Thanx Bro...works perfectly :)

@SankalpRanade Happy to help you :)