>Hello Borislav,
>
>Thanks. I don;t understand this second INNER JOIN :
>
>INNER JOIN rv_ICPRIC ON Rv_icpric.itemno) = ALLTRIM(Crs_pricelist.itemnumber);
>
>Where did you get Crs_pricelist.itemnumber ? Can up please check this?
>
>John

Sorry, copy and paste problem :-)

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