Re: A Simple SQL Query
I think you want independent aggregate function for tables
purchase_details and sales_details
Maybe you need two SQL sentences:
select pd_item, sum(pd_qty) pd_qty
from purchase_details
group by pd_item
into temp t1;
SELECT SD_ITEM, SUM(SD_QTY), pd_qty
FROM SALES_DETAIL, OUTER t1
WHERE SD_ITEM = PD_ITEM
GROUP BY SD_ITEM, pd_qty
Ivan Velasquez
}
}Can someone help me solve this simple problem ? There are two tables,
and
}I need a summary of the items. For SUM(SD_QTY) I get the right figure,
}but for SUM(PD_QTY) I get the figure multiplied by 3.
}
}------------------- Table : PURCHASE_DETAILS
}----------------------------
} PD_ITEM PD_QTY
} 3 2
}
}------------------- Table : SALES_DETAILS
}----------------------------
}SD_ITEM SD_QTY
}3 100
}3 1
}3 3
}4 200
}SB 1
}---------------------- S Q L
}--------------------------------------------------------------
}SELECT SD_ITEM, SUM(SD_QTY), SUM(PD_QTY)
}FROM SALES_DETAILS, PURCHASE_DETAILS
}WHERE SD_ITEM = PD_ITEM (+)
}GROUP BY SD_ITEM;
}----------------------- Result
}--------------------------------------------------------
}SD_ITEM Sum(SD_QTY) Sum(PD_QTY)
}3 104 6 <-------- This should
}be 2
}4 200
}SB 1
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com