How can I include a column that exists in a nested table in a where condition? I want to return the filtered nested table without unsetting it. Below is my table. Table 1 Col1 Col2 Col3 (Nested Table) =3D=3D=3D=3D =3D=3D=3D=3D = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 1 X see below Col3 Row 1 Col3 (Row 1) colA colB ColC ColD =3D=3D=3D=3D =3D=3D=3D=3D =3D=3D=3D=3D =3D=3D=3D=3D=3D 1 2 3 4 1 3 4 4 3 4 5 6 This is the type of query I would like to do, but I don't know if it is possible. SELECT * FROM Table 1 WHERE Col1 =3D 1 AND Col3.ColA =3D 1 The return from the query should be the following: 1 X (1, 2, 3, 4), (1, 3, 4, 4)=20 Thanks, San ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------