| Subject | update join syntax |
|---|---|
| Author | Ichiro Kobayashi |
| Post date | 2010-10-27T08:12:36Z |
Dear All,
I would like to ask what should I write a syntax like this on my FB 1.5 ?
***
UPDATE table1
SET table1.field1='F'
WHERE NOT EXISTS
(SELECT id FROM table2 WHERE table1.id=table1.id);
***
Thank you in Advance !
~ichiro~
I would like to ask what should I write a syntax like this on my FB 1.5 ?
***
UPDATE table1
SET table1.field1='F'
WHERE NOT EXISTS
(SELECT id FROM table2 WHERE table1.id=table1.id);
***
Thank you in Advance !
~ichiro~