This is a discussion on Re: union subqueries in "from" clause (IDS 9.4) within the Informix forums, part of the Database Server Software category; --> It's a little confusing on principle but when usaed properly you could some very interseting things. The only down ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| It's a little confusing on principle but when usaed properly you could some very interseting things. The only down I've seen on this multiset construct is that it isn'y able to handle first. J. Dan escribió: > Thanks again to everyone who suggested the Table-Multiset solution to this > problem. It's something I don't think I'd ever have figured out on my own. > And, after spending some time reading the docs on multisets & virtual tables > & collection subqueries & collection-derived tables, I still find it a bit > confusing... For my purposes (selecting from the results of a subquery), it > seems like quite a lot of semantic structure for something that's otherwise > fairly simple. But it works, which is the important part. And maybe after > another read or two it will make more sense. > > > sending to informix-list |
| Thread Tools | |
| Display Modes | |
|
|