Hi
I'm joining two tables and selecting the key LPH.LPH_LAMPIRAN_NO as distinct. However it returns me with multiple values of the same LPH.LPH_LAMPIRAN_NO. Why is it so? Here is my statement

Select distinct(LPH.LPH_LAMPIRAN_NO), POD.POD_REF_NO, LPH.LPH_UPLOAD_DATE, LPD.LPD_ITEM_CODE, LPH.LPH_EPO_NO, EPH.EPH_CATEGORY from T_PO_DTL POD, T_LAMPIRAN_HDR LPH, T_EPO_HDR EPH, T_LAMPIRAN_DTL LPD WHERE POD.POD_REF_NO=LPH.LPH_LAMPIRAN_NO and EPH.EPH_EPO_NO=LPH.LPH_EPO_NO and POD.POD_PO_NO = 'alpo9283 ' and LPD.LPD_LAMPIRAN_NO = POD.POD_REF_NO

Thanks