>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
It was a typo in Boris query. Check the query I posted. I use your first query as derived table and then join it with two other views. I also don't think you need to use ALLTRIM - can you explain the reason for this?
BTW, the query I posted you can run in PERVASIVE rather than in VFP.
If it's not broken, fix it until it is.
My Blog