SELECT SUM Syntax

[TomBarrand]

I have the following tables, FOB and FOB_Size

FOB FOB_Size

FOB_No PK FOB_No Key
Purch_Ord_Line_No FK Size_No Key
FOB_Date Size_Quantity
Detailed_Size_Quantity

I would like to select the SUM of Detailed_Size_Quantity where the FOB.Date is between two FOB.FOB_Dates.
Any suggestions would be appreciated

Thanks

 

[Spellman]

Maybe something like this

Select Sum(FOB_Size.Detailed_Size_Quantity) From FOB Inner join FOB_Size on fob.fob_no = fob_size.fob_no where fob.fob_date > start date and fob.fob_date > end date

Hope this helps. If it's not what your looking for let me know.

 

[vishnuprasad]

This might be Ok.

Select Sum(FOB_Size.Detailed_Size_Quantity) From FOB Inner join FOB_Size on fob_size.fob_no = fob.fob_no where fob.fob_date is between
<startdate> and <enddate>

In the place of these start and end dates you can substitute some subquery statements related to fob.fob_date.
Be careful with dateformat, better use a convert function on the dates and make them of the same format before comparision.