Subject | Update format |
---|---|
Author | Cesar L. Meloni |
Post date | 2008-05-02T16:54:28Z |
Hello everyone!!!
I am migrating an application from MySQL to FB2.0.3 (on Linux).
Can not solve the following query:
UPDATE tambe1 T1
INNER JOIN table2 T2
ON T1.id = T2.id
SET T1.value = T2.value
WHERE T1.id = 199522
It works well in MySQL and Access.
I also have other similarities with delete.
Thank you all !!!
Cesar L. Meloni
Unifix
I am migrating an application from MySQL to FB2.0.3 (on Linux).
Can not solve the following query:
UPDATE tambe1 T1
INNER JOIN table2 T2
ON T1.id = T2.id
SET T1.value = T2.value
WHERE T1.id = 199522
It works well in MySQL and Access.
I also have other similarities with delete.
Thank you all !!!
Cesar L. Meloni
Unifix