Re: Need help on the correct SQL syntax

Posted in 2003

Jesus Antonio Santos Giraldo — Wed, 17 Dec 2003 01:19:42 -0500 — source: Usenet: comp.databases.informix

I think this syntax is only supported in XPS. If you have IDS or other... you are out of look and have to use some kind of correlated query ie: WHERE EXISTS(...) miyaki wrote: > 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 > -- Atte, Jes's Antonio Santos Giraldo jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list