Skip to Main Content

Subquery in Select Statement in ODI12C mappings

BCVJul 28 2022

Hi All,
I want to achieve below SQL query in ODI 12C Mappings , i am mainly looking for the help to implement the subquery in select statement . Please help with reference , your help would be appreciated !
select column1 ,
column2 ,
(select column1 from tab1 a where a.column1 =M.column1 ) column3,
column4 from
TableM M join TableN N
where M.eno = N.eno ;

This post has been answered by Gianni Ceresa on Jul 28 2022
Jump to Answer
Post Details