Re: SQL question ...

ue key in table A is (C1,C2)? > :Hasn't anyone else ever wished there could be syntax like: > :delete from A > : where (C1,C2) in (select C1,C2 from B) > > Yes this syntax should be allowed. > The problem is big enough that Informix ought to add it, and go to the > SQL standard commity with it if it isn't allready part of the > standard. > This is so true. The use of exists as suggested by many is hardly > usefull in most cases. It's extremly slow if there are more than a few > rows in the tables. > If this use of exists could have been made fast by Informix the above > syntax *may* not be needed. Even if the exists clause were fast enough, I think the syntax above is more elegant. What would it take to get it done? This has actually bugged me more times than the case insensitive search thing, although they should both be implemented. -- Sincerly, Doug Wilson(dougw@amgen.com) *** The opinions expressed here are my own and not neccessarily *** *** anyone elses **** *** Disclaimer: These are the opinions of the poster not Amgen Inc.***