General information
Category:
Coding, syntax & commands
Title:
SQL Update with a SQL Select
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only