Re: table of tables SQL syntax query
From: Adrian Billington <billiauk_at_yahoo.co.uk>
Date: 15 Apr 2002 00:52:07 -0700
Message-ID: <dee17a9f.0204142352.34ac214f_at_posting.google.com>
Date: 15 Apr 2002 00:52:07 -0700
Message-ID: <dee17a9f.0204142352.34ac214f_at_posting.google.com>
Barry
Use the TABLE expression to be able to access data "inside" the nested table...
SELECT x
SELECT DISTINCT x
, nt.column_value as y_value
FROM testtable
, TABLE(y) nt
WHERE nt.column_value in (1,3)
/
FROM testtable
WHERE nt.column_value IN (1,3)
/
Regards
Adrian Received on Mon Apr 15 2002 - 09:52:07 CEST