Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Combining Grouped Sum with different Select query
I see, thank you for the article. This will be good to know in the future. -
Combining Grouped Sum with different Select query
Excellent, that worked. What does LEFT JOIN do? How is that different than a normal join? In the past, when I wanted to join two tables, I would list them both after FROM (e.g., FROM Inventory I, Sales S) Thanks. -
Combining Grouped Sum with different Select query
Table Sales CUSIP PurchDate SaleDate UnitsSold Proceeds 74112E109 08/05/08 4/17/09 5,950 8,291.04 74112E109 08/05/08 4/20/09 3,365 4,996.90 04648X107 10/08/08 4/20/09 7,500 569.98 04648X107 10/08/08 4/20/09 192,500 12,377.42 04648X107 10/09/08 4/20/09 7,500...
