Re: table of tables SQL syntax query
From: barry <bbulsara23_at_hotmail.com>
Date: 15 Apr 2002 06:27:19 -0700
Message-ID: <747f1dec.0204150527.5776271_at_posting.google.com>
Date: 15 Apr 2002 06:27:19 -0700
Message-ID: <747f1dec.0204150527.5776271_at_posting.google.com>
Thanks - so simple but I'd have never got it. Barry
billiauk_at_yahoo.co.uk (Adrian Billington) wrote in message news:<dee17a9f.0204142352.34ac214f_at_posting.google.com>...
> Barry
>
> Use the TABLE expression to be able to access data "inside" the nested table...
>
> SELECT x
> , nt.column_value as y_value
> FROM testtable
> , TABLE(y) nt
> WHERE nt.column_value in (1,3)
> /
>
> SELECT DISTINCT x
> FROM testtable
> , TABLE(y) nt
> WHERE nt.column_value IN (1,3)
> /
>
> Regards
>
> Adrian
Received on Mon Apr 15 2002 - 15:27:19 CEST