I am trying to write a simple Update query that is based on a select statement involving a 2nd table and for some reason I keep getting an error:
Update "Table One"
Set "Field One" = 'x'
and I want this to be based on the results of a select statement from another table such as
Select * from "Table Two" where "Field 10" = '31'
And "Field 15" > '11/15/2011'
I think I'm just missing some logic in combining them because the select statement seems to run fine on its own.