[SOLVED] Need assistance with a query...

[dlebowski]

I need a query that will take what each seller sold times the quantity and get a grand total for multiple lots sold.  I'm not sure how to go about achieving this.

 

Here is what I have:

 

FIELDS:

Lot    Price    Quantity    Seller

1      3            1            36

2      4            2            36

3      20          1            8

4      13          3            8

5      12          1            87

 

I need to have each seller get a grand total of what they sold.  So the end result would be:

 

Seller    Total

36          11            ((3*1)+(4*2))

8            59            ((20*1)+(13*3))

87          12              (12*1)       

[watthehell]

SELECT Seller, sum( Price * Quantity ) FROM `Table_Name` GROUP BY Seller;

 

 

check this

[dlebowski]

I got it.  Here is what I did:

 

SELECT sum(SellingPrice * LotQuantity) FROM lots WHERE Date='$Date' AND SellerNumber='$Seller'

[dlebowski]

Thanks for helping out man.