Re: How to get rid of MULTISET in DB queries.

Thanks Art !! Yeah the queries are in thhis form only. Thanks for your suggestion, I will try to use Join for these queries. Thanks for your reply. Regards, Meenu On Thu, Jun 17, 2010 at 10:25 PM, Art Kagel <art.kagel@gmail.com> wrote: > What are you using MULTISET for? If you are using it to simiulate derived > tables as in SELECT ... FROM TABLE(MULTISET(SELECT....)), and you are > running 11.50, you can just use derived tables as in: SELECT ... FROM > (SELECT ...), though I can think of VERY few queries that are written using > derived tables that couldn't be rewritten as a simple join! And they > usually perform better that way. The only derived table queries I know of > that can't be rewritten as a join are those where the subquery returns > aggregates and you want to join the aggregates to non-aggregated rows or > aggregates at different levels. > > Art > > > Advanced DataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, implicitly, > or by inference. Neither do those opinions reflect those of other > individuals affiliated with any entity with which I am affiliated nor those > of the entities themselves. > > > > On Thu, Jun 17, 2010 at 7:47 AM, meenu sharma <meenu.thapliyal@gmail.com>wrote: > >> Hi, >> >> I have a requirement to remove MULTISET from the SQL queries. >> >> Please suggest some alternative ways in which I can implement my queries >> without MULTISET. >> >> Any help will be greatly appreciated. >> >> Thanks and Regards, >> Meenu Thapliyal >> >> _______________________________________________ >> Informix-list mailing list >> Informix-list@iiug.org >> http://www.iiug.org/mailman/listinfo/informix-list >> >> > --001485f87c3cd09c90048958b56a