I am making a project in VB, which comprises of 6 tables viz. (1)DDDetails, (2)BillDetails, (3) ReleasedOrderdetails, (4)ReceiptRegister,(5)RODD,(6)ROBill .

ReleaseorderDetails
ReleasedOrderNo(primary key)
Other fields

ReceiptRegister
ReleasedOrderNo(Foreign key)
Other fields

RODD
ReleasedOrderNo(foreign key)
DDNo(foreign key)

DDDetails
DDNo(primary key)
Other fields

ROBill
ReleasedOrderNo(foreign key)
BillNo(foreign key)

BillDetails
BillNo(primary key)
Other fields
why following query is giving absurd result?Iam using it in VB project's adodc1 recordsource field.

SELECT ReleasedOrderDetails.ReleasedOrderNo,SUM(DDDetails .DDAmount),SUM(BiIIDetails.BillAmount),SUM(Receipt Register.OrderedWt),SUM(BillDetails.BillQuantity) ,SUM(DDDetails.DDAmount)-SUM(BiIIDetails.BillAmount),SUM(ReceiptRegister.Or deredWt)-SUM(BillDetails.BillQuantity) FROM ReceiptRegister,ROBill,RODD,BillDetails,DDDetails, ReleasedOrderDetails WHERE DDDetails.DDNo=RODD.DDNo AND RODD.ReleasedOrderNo=ReleasedOrderDetails.Released OrderNo AND ReleasedOrderDetails.ReleasedOrderNo=RoBill.Releas edOrderNo AND ROBill.BillNo=BillDetails.BillNo AND ReleasedOrderDetails.ReleasedOrderNo =Receiptregister.ReleasedOrderNo GROUP BY ReleasedOrderDetails.ReleasedOrderNo ORDER BY ReleasedOrderDetails.ReleasedOrderNo