Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.