Use of TABLE Keyword select statement

General
Enthusiast

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.

1 REPLY
Enthusiast

Re: Use of TABLE Keyword select statement

Check out manual  on SQL functions.

This is syntax for using Table UDF.

Rglass