Re: Multiset / Inline Select

More importantly why do you want to do an inline select? As I have ranted before you don't need them except for some very particular cases. in4mixDBA wrote: > Hello all, > > I am running Informix 7.31.FD7 > > I would like to do an inline select. I found the SQL syntax for > informix as: > > SELECT * FROM TABLE(MULTISET(SELECT * FROM mytable))> > Though, it doesn't work and just gives a general syntax error. > > Do you know if the multiset is supported in my version (7.31) or is > there another syntax I should be using? > > Thank You, > > have a great day, > > Dave > in4mixDBA@gmail.com