Let's say I have 2 tables, A an B and I Inner Join them on a common ID field. Each table has a Quantity Field. For all records in (A Join B) I want to multiply A.Quantity * B.Quantity and Sum All of the Results. This is similar to the SUMPRODUCT Function in Microsoft Excel. Is this possible in SQL?? If so, how??