BI Publisher (MOSC)

MOSC Banner

Multiple Data Sets

edited Dec 30, 2010 5:06AM in BI Publisher (MOSC) 1 commentAnswered
I am trying to use values from one data set in another data set where clause, is this possible?

Example:

DataSet1

Select A,B,C

From TableA

Where A=1

DataSet2

Select E,F,G

From Table B

where DataSet1.A = DataSet2.E

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center