我希望从SQL Server向laravel编写查询。
我想这样写SQL：
select SUM(TRANSTKD.TRD_U_PRC) as prctotal from DOCINFO
inner join [TRANSTKH] on [DOCINFO].[DI_KEY] = [TRANSTKH].[TRH_DI]
inner join [SKUMASTER]
inner join [TRANSTKD]
on [TRANSTKD].[TRD_SKU] = [SKUMASTER].[SKU_KEY]
on [TRANSTKH].[TRH_KEY] = [TRANSTKD].[TRD_TRH]
where [DOCINFO].[DI_KEY] = 148978
GROUP BY [SKUMASTER].[SKU_CODE];
在laravel查询下面尝试此操作
DB::table('DOCINFO')
->join('TRANSTKH','DOCINFO.DI_KEY','=','TRANSTKH.TRH_DI')
->join('TRANSTKD','TRANSTKH.TRH_KEY','TRANSTKD.TRD_TRH')
->join('SKUMASTER','TRANSTKD.TRD_SKU','SKUMASTER.SKU_KEY')
->select(DB::raw('SUM(TRANSTKD.TRD_U_PRC) as prctotal'))
->where('DOCINFO.DI_KEY',148978)
->groupBy('SKUMASTER.SKU_CODE')
->get();
让我知道它如何帮助您！