Simepl query needed to JOIN three tables

[mameha1977]

I wish to find out the total sales per industry using SQL.

Tables:


- Sales
- Customer
- Industry

The tables are linked as follows:
- Sales is linked to Customer by Customer_ID
- Customer is linked to Industry by Industry_ID

The Sales table contains each sale (price + customer_id)
The Customer table contains each customer (customer_id, industry_id)
The Industry table contains each industry (industry_id, industry_name)

I simply want to get the total sales for each Industry using SQL, with the result looking like this:

INDUSTRY_NAME | TOTAL SALES
Industry4 9876
Industry2 8889
Industry3 7787
Industry1 2898

Can anyone work out the Query needed to select this data?

[alansidman]

Crossposted: http://forums.aspfree.com/microsoft-...es-536988.html

See my response at the other forum.

[mameha1977]

resolved:

SELECT TEG_Industry.Industry, Round(Sum(TEG_sales.PRICE), 0) AS TotalSales
FROM (TEG_Industry INNER JOIN TEG_Customer ON TEG_Industry.IndustryID = TEG_Customer.Branch) INNER JOIN TEG_sales ON TEG_Customer.CustomerNo = TEG_sales.COMPANYID
GROUP BY TEG_Industry.Industry
ORDER BY Sum(TEG_sales.PRICE) DESC;