you can break the query in to smaller queries and build it.
i'm too lazy to write the whole query for you. it would be something like this to get started with.
DB::join(DB::raw('(' . DB::table('bi000')->select('mt000.BarCode' , 'bu000.Qty')->join('mt000', 'bi000.MatGUID', '=', 'bi000.ParentGUID')->toSql() . ') as bills'))->join('FirstBegInvMyd', 'FirstBegInvMyd.BarCode', '=', 'bills.BarCode')
Last updated
8 years ago.
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast