SELECT SUM( Total ),Name,LastName,Gender FROM order_detail
LEFT JOIN cusorder ON ( cusorder.OrderID = order_detail.OrderID )
LEFT JOIN member ON ( cusorder.MemberID = member.MemberID )
GROUP BY cusorder.MemberID
Tag : PHP
Date :
2016-03-23 20:08:31
By :
narutokarp
View :
765
Reply :
2
No. 1
Guest
Code
SELECT SUM( Total ),Name,LastName,Gender,cusorder.MemberID FROM order_detail
LEFT JOIN cusorder ON ( cusorder.OrderID = order_detail.OrderID )
LEFT JOIN member ON ( cusorder.MemberID = member.MemberID )
GROUP BY cusorder.MemberID
Load balance : Server 05
