Forum Create join without "ON" clause

riturajraina

posted 8 years ago

Database Eloquent Laravel.io

Last updated 1 year ago.

hunglmtb

replied 7 years ago

I do it like this

A::join(B,"A.ID",'=',"A.ID")

Hope this help :)

Last updated 7 years ago.

jasonrust

replied 7 years ago

Hi @riturajraina, try it:

$query = DB::table('matchscore_profile_data AS a');

    $query
        ->join('matchscore_segment_relevance as asr', 'asr.segment_name', '=', 'a.segment')
        ->join('matchscore_segment_relevance as bsr', 'bsr.segment_name', '=', 'a.segment')
        ->select('matchscore_profile_data.*', 'asr.segment_name as asr_segment_name ', 'bsr.segment_name as bsr_segment_name');

return $query;

Last updated 7 years ago.