How to create a data flow using "Enter SQL" option to join two tables
Summary
I want to create a data flow by joining two tables and want to write the join statement using "Enter SQL" optionContent
Hi,
I want to create a data flow by joining two tables and want to write the join statement using "Enter SQL" option.
This gives me query error.
My requirement is to join tables vb_aggregated_access and vb_inventory_report and the query I am using is
select * from vb_aggregated_access a full outer join
vb_inventory_report b ON LOWER(a.POD_NAME)=LOWER(b.PSM_INSTANCE) ;
>gives me query error
Is there a way to do this in OAC?
0