mysql 链表查询，设置参数查询

最新推荐文章于 2022-12-06 22:30:18 发布

weixin_30920091

最新推荐文章于 2022-12-06 22:30:18 发布

阅读量109

点赞数

文章标签：数据结构与算法数据库

原文链接：http://www.cnblogs.com/lbjcoder/p/6295595.html

版权

set @a=to_days(now());
select d.UserID,d.OrderID,d.ProductID,sum(PayMoney) as PayMoney,Count(*) as PayCount,RealName,Phone,o.OrderMoney,o.OrderNo,o.OrderDate,b.BankName,b.BankAddress,b.CardNo,max(d.PayTime) as Times ,p.ProductName
from InvestOrderDetail d
left join UserInfo u on d.UserID=u.UserID
left join InvestOrder o on d.OrderID=o.OrderID
left join InvestProduct p on d.ProductID=p.ProductID
left join UserBank b on d.UserID=b.UserID and b.IsDefault=1
where  to_days(d.PayTime)=@a GROUP BY d.UserID,d.OrderID,d.ProductID