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)
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.