MULTISETS (and how to get data out of them)

Posted in 2003

Sean Kelsey — 3 Sep 2003 08:02:22 -0700 — source: Usenet: comp.databases.informix

Afternoon all... IDS 9.30.TC4 on W2KAS I have a table containing a multiset of data in the following format ID1 Members 1 MULTISET{101,102,103,104,105,106} 2 MULTISET{201,202,203,204,205,206} 3 MULTISET{301,302,303,304,305,306} 4 MULTISET{401,402,403,404,405,406} etc... Because I'm fairly new to MULTISETs, what type of query (SELECT) would I need to perform in order to get the output in the following format:- ID1 Member 1 101 1 102 1 103 1 104 ... 2 201 2 202 2 203 2 204 ... All help, as ever, greatly appreciated P.S. my direct e-mail address is sean.kelsey"at"Moneyline.com Many thanks S.