I have the following problem. I want to summerize records from two table
which are related to each other by a field.
As result from the SELECT statement I want the following
Custnr Money Quantity
100 90 300
150 50 110
I tried the following
SELET Custnr, SUM(DISTINCT Money), SUM(DISTINCT Quantity) FROM TableOne,
TableTwo INNER JOIN TableOne.Custnr = TableTwo.Custnr.
This works, but I think it's not the proper way (performance etc) to do it
Is this the correct way of selecting the records, or is there a more