afreenraja (8/29/2016)

---

Thanks for your quick response.

Please find my answers:

Which table does the ordertype column live in? Exp

Are you summing the sale column from the sale table, or does Exp have a sale column too? Summing sale from Exp table.

I assume the Exp value is from the Exp table. Is that correct? Yes

Which area do you want to group by: S.area or T.area? S.Area

Is there a one to many relationship between the Sale and Exp tables? No

Do you want the simple totals from both tables, or the totals as multiplied by the join? Total only from Exp table.

Please let me know if you want any more clarifications.