select subq.sub_col1,subq.sub_col2,c.c2,c.c3.c.c4 select a.col1 sub_col1,b.col2 sub_col2,b.col3 sub_col3 Schemaname.Tab1 a, (select col1,col2 col3 from Schemaname.Tab2) b on a.col1=b.col1) as subq, TABLE (Schemaname.Tab3 (subq.sub_col1,subq.sub_col3,null,null)) as c (c1,c2,c3,c4) where subq.sub_col1=c.c1
Can anyone explain what below sql does. first time i am seeing use of TABLE keyword in SELECT statement.
Please hlep to understand this. Thanks in advance.