Need help on the correct SQL syntax

Posted in 2003

miyaki — Wed, 17 Dec 2003 00:19:14 -0800 (PST) — source: Usenet: comp.databases.informix

Hi all, What is the valid delete command in Informix that can referring to 2 tables? E.g. delete from table1 where table1.field1 = table2.field2 Similiar to the SQL statement as below used in Microsoft SQL server. DELETE FROM [Order Details] FROM [Order Details] AS OD JOIN Orders AS O ON OD.orderid = O.orderid WHERE customerid = 'VINET' Thanks & regards, Miyaki __________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ sending to informix-list