>Sergey,
>
>exactly! However if I 'extend' this little example with
>
>insert into curOrdertype values(3,"nbrthree")
>
>and
>
>insert into curClient values(4,"George")
>
>this will give me a 0.00 for all orders ;(
>
>Regards,
Use my or Boris code instead. Looks like derived table is the solution. Without derived table VFP seems to get confused - I got the same wrong results.
If it's not broken, fix it until it is.
My Blog