>Dear u send me the coding thanks
>but this is not workin properly
>i m using vfp 5.0
>
>I change some thing in ur coding please follow it
>
>select st.Item_code, ;
> nvl(pr.consg_no, nvl(rc.consg_no, sl.consg_no)) as 'consg_no',;
> nvl(rc.qty,0) as rcptqty, ;
> nvl(pr.qty,0) as purchqty, ;
> nvl(sl.qty,0) as salesqty ;
> from sl st ;
> left join purchase pr on st.Item_code = pr.Item_code ;
> left join receipt rc on st.Item_code = rc.Item_code ;
> left join sales sl on st.Item_code = sl.Item_code ;
> order by st.Item_code, consg_no ;
> into cursor crsReport
I said roughly as I remember. You should refine it for your needs. I'd never know what's proper for you.
Cetin