>I was doing a search for the ability to do a select in a SQL Update statement came across this in one of the threads.
>
>Has anyone gotten anything like this to work in VFP?
>If so, could you share some examples? Or any examples of Update/Select working together.
>
>UDPATE t1
> SET rate = rate + (SELECT increase FROM t2 WHERE id = t1.id)
>
>Thanks,
>Steve

Hello Stephen,

I think this is not possible with VFP. but let me try other RDBMS.

Bye
Jayesh