Re: SQL question

Posted in 2000

Art S. Kagel — Tue, 18 Apr 2000 13:42:17 -0400 — source: Informix-list mailing list archive (1991-1998)

Joe Trubisz wrote: > Hi... > > Given: > create table r( > a int,> b list(row(x int, y int) not null)); > > How do I formulate a query which will list > for each 'a', all the values of 'y'? Umm: SELECT a, b.y FROM r ORDER BY 1,2; Art S. Kagel