All Forums General
NewbieTD 25 posts Joined 05/13
18 Jul 2016
Use of TABLE Keyword select statement
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

Hi All,
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.
 

Glass 225 posts Joined 04/10
18 Jul 2016

Check out manual  on SQL functions.
This is syntax for using Table UDF.
 
Rglass

You must sign in to leave a comment.