Oracle Analytics Cloud and Server

Products Banner

How to create a data flow using "Enter SQL" option to join two tables

Received Response
21
Views
2
Comments

Summary

I want to create a data flow by joining two tables and want to write the join statement using "Enter SQL" option

Content

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?

Thanks in advance,

Chethana

Answers