客服电话
APP下载
迪恩网络APP
随时随地掌握行业动态
官方微信
扫描二维码
关注迪恩网络微信公众号
|
情况：多表联合查询（三表及以上联合查询） 分析： A left join B left join C left join D 假如： 表B、C、D都与表A关联查询 A left join B 4条数据 A left join C 2条数据 A left join D 1条数据 那么： 结果会有4条数据：B表查询数据正确；C表查询数据重复2次；D表数据重复4次 解决方案： 使用子查询（下面是laravel框架写法） $withdraw_sum=Acceptance::query()->from('vt_withdraw_master_order')->where('admin_approval_status',config('constant.WITHDRAW_APPROVAL_STATUS.approved'))->groupBy('acceptance_id')->select('acceptance_id',DB::raw('sum(order_amount) as given_money'))->getQuery();
->leftJoinSub($withdraw_sum,'withdraw_sum','vt_acceptance.id','=','withdraw_sum.acceptance_id')
Enjoy it ! |
2022-08-30
2022-07-08
2022-08-17
2022-11-06
2022-08-18
librespeed/speedtest: Self-hosted Speedtest for HTML5 and more. Easy setup, exam
avehtari/BDA_m_demos: Bayesian Data Analysis demos for Matlab/Octave
女人怀孕后，为了有一个健康聪明的宝宝，经历各种体检、筛查。其实这些体检和筛查中的
typeTKeyByte=arrayofByte;TDesMode=(dmEncry,dmDecry);functionEncryStr(Str,Key:Str
medfreeman/markdown-it-toc-and-anchor: markdown-it plugin to add a toc and ancho
Pexip Infinity before 27.3 allows remote attackers to trigger a software abort v
Exposure of Sensitive Information in Telecom application prior to SMR Jul-2022 R
facebook/folly: An open-source C++ library developed and used at Facebook.
sydney0zq/covid-19-detection: The implementation of A Weakly-supervised Framewor
离中国最远的国家是阿根廷。从太平洋直线计算，即往东线走，北京到阿根廷的布宜诺斯艾
请发表评论