CODEWITHSUNDEEP
laraveleloquent
Skandarajah Shyamalan
Skandarajah Shyamalan

Reputation: 95

how to convert query this query to laravel

SELECT *
FROM `digital_useraccess`
left join digital_publisher ON
access_publisher = pub_auto
left join digital_issue ON
issue_publisher = pub_auto
WHERE 1

without using laravel DB class method

Upvotes: 0

Views: 56

Answers (2)

Moubarak Hayal
Moubarak Hayal

Reputation: 209

This might help :

  ::query()->where('<cplumn>' , '<operator>' ,
 '<value>')->leftJoin('digital_publisher', 'access_publisher',
 '=','pub_auto')->leftJoin('digital_issue', 'issue_publisher', '=',
 'pub_auto')->select('<columns>')->get();/find();/first();

Upvotes: 0

Lim Kean Phang
Lim Kean Phang

Reputation: 501

Try this as reference

    ModelName::where(conditions)
    ->leftjoin('digital_publisher','access_publisher','pub_auto')
    ->leftjoin('digital_issue','issue_publisher ','pub_auto')
    ->select('column_1','column_2',...)->get();

Upvotes: 1

Related Questions