SELECT DISTINCT Rv_uxdetail.custcode,; Rv_uxdetail.itemnumber,; Rv_arcus.priclist,; Rv_icpric.desc,; Rv_icpric.baseprice,; Rv_icpric.baseunit; FROM rv_UXDETAIL; INNER JOIN rv_ARCUS ON Rv_arcus.idcust == rv_UXDETAIL.custcode; INNER JOIN rv_ICPRIC ON Rv_icpric.itemno == rv_UXDETAIL.itemnumber; && I agree with Naomi, there is No need for ALLTRIM() INTO CURSOR crs_CurrentPrice