how to use where condition on a aggreate sum column present in a .

S

Satish

my view:

SELECT tbl_Shipment.*, tbl_FPO.PaymentTermDays, tbl_FPO.FPO,
tbl_FPO.FPODate, (select sum(Amount) from tbl_fpomaterials where
tbl_fpomaterials.fpoid=tbl_fpo.id) AS Amount,
tbl_Vendor_Payment_details.BNFBankInfo, tbl_Payables.Discount,
tbl_Payables.BalanceDue, tbl_FPO.PaymentCurrency, tbl_FPO.Vendor,
tbl_Payables.ID AS PaymentID, tbl_FPO.ShipTo
FROM tbl_Payables RIGHT JOIN ((tbl_Shipment LEFT JOIN tbl_FPO ON
tbl_Shipment.PONo = tbl_FPO.ID) LEFT JOIN tbl_Vendor_Payment_details ON
tbl_Shipment.VenPayDetails = tbl_Vendor_Payment_details.ID) ON
tbl_Payables.FPONo = tbl_FPO.ID;

Select Statement:

SELECT q_Payable_Accounts.*
FROM q_Payable_Accounts
WHERE (((q_Payable_Accounts.Amount)>200 And
(q_Payable_Accounts.Amount)<4000));

problem:

1)Query complex

how to perform a where condition on an sum aggreate column present in my
view ,can any one help me out
 
Top