Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
IEyeScream
Starting Member
6 Posts |
 Posted - 2013-05-22 : 02:53:34
|
| List of customers including their ordered product and its price per product. Also include subtotal.Click URL to See the Tables [url]https://fbcdn-sphotos-b-a.akamaihd.net/hphotos-ak-frc3/261607_4470109405442_2069214335_n.jpg[/url] need help for the query please |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-05-22 : 03:31:13
|
| --this?SELECT c.CustomerCode, c.FirstName, sp.ProdCode, SUM(sp.CurrentPrice) PricePerProductFROM Customer cJOIN Order o ON o.CustomerCode = c.CustomerCodeJOIN OrderDetails od ON od.OrderCode = o.OrderCodeJOIN SetPrice sp ON sp.SetPriceCode = od.SetPriceCode GROUP BY c.CustomerCode, c.FirstName, sp.ProdCode--Chandu |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-22 : 03:44:14
|
| Make sure you use LEFT JOIN instead of JOIN in above case if you've Customers who have not ordered yet and still want to retrieve them in your result.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
|
|
|
Help