LeftJoin on Leftjoin

Hi Everybody,

i have a query :

$objects = DB::table('catalog') ->leftJoin('products', 'sku', '=', 'identifier') ->leftJoin('prices','product_id','=','id') ->get();

Now the table products leftjoin on catalog, but i also want prices to leftjoin on products. but it looks like it crashes becauses it tries to join on catalog.

SilenceBringer

4 years ago

Level 56

@theprofit

$objects = DB::table('catalog')
    ->leftJoin('products', 'sku', 'identifier')
    ->leftJoin('prices', 'prices.product_id', 'products.id')
    ->get();

Please or to participate in this conversation.