UPDATE table1 t1
SET t1.field1='F'
WHERE NOT EXISTS
(SELECT * FROM table2 t2 WHERE t1.id=t2.id);

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Ichiro Kobayashi
Sent: 27. oktober 2010 10:13
To: firebird-support
Subject: [firebird-support] update join syntax

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~


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links