SELECT
t1.ProductId,t1.name,t1.MeasurementUnit,t1.sku,
(SELECT rt3.Quantity FROM Product rt1, Inventory_BillSheet rt2 ,Inventory_BillSheet_Item rt3
where ) as cksl
FROM Product t1, Inventory_BillSheet t2 ,Inventory_BillSheet_Item t3 ,Inventory_Consignor t4
WHERE t1.ProductId=t3.ProductId AND t2.BillSheetId=t3.BillSheetId
AND t2.ConsignorId=t4.ConsignorId子查询里面的where条件怎么和父表关联
t1.ProductId,t1.name,t1.MeasurementUnit,t1.sku,
(SELECT rt3.Quantity FROM Product rt1, Inventory_BillSheet rt2 ,Inventory_BillSheet_Item rt3
where ) as cksl
FROM Product t1, Inventory_BillSheet t2 ,Inventory_BillSheet_Item t3 ,Inventory_Consignor t4
WHERE t1.ProductId=t3.ProductId AND t2.BillSheetId=t3.BillSheetId
AND t2.ConsignorId=t4.ConsignorId子查询里面的where条件怎么和父表关联
SELECT SUM(Quantity)
FROM Inventory_BillSheet_Item
WHERE BillSheetId=t1.ProductId AND t2.BillSheetId = BillSheetId
) AS cksl
FROM Product t1, Inventory_BillSheet t2, Inventory_BillSheet_Item t3, Inventory_Consignor t4
WHERE t1.ProductId = t3.ProductId
AND t2.BillSheetId = t3.BillSheetId
AND t2.ConsignorId = t4.ConsignorId