Re: Need help on the correct SQL syntax

Posted in 2003

Xuanhai Carmichael — Wed, 17 Dec 2003 11:06:16 -0800 — source: Usenet: comp.databases.informix

Miyaki, Try the below syntax: DELETE FROM [Order Details] where orderid IN (select orderid from Orders where customerid = 'VINET') Good luck. Xuanhai >>> miyaki <lcib@yahoo.com> 12/17/2003 12:19:14 AM >>> 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 sending to informix-list