Oracle Discoverer Administrator: join condition

Marino Ljubic · *nix forums beginner Joined: 10 May 2005 Posts: 20

<onlysendspamtothisaddress@yahoo.com> wrote in message
news:1108156549.371989.3520@g14g2000cwa.googlegroups.com

onlysendspamtothisaddress · *nix forums beginner Joined: 24 Mar 2005 Posts: 4

Aloha,

Using Oracle Discoverer Administrator, is it possible to join one table
to another table with a specific condition being true? If so, how?

For example this SQL join clause

JOIN table2 ON table2.id = table1.id and table2.otherField='TRUE'

One thought I had was to create a field in table1 with the value of
true for all records, then I can edit the join in the Edit Join dialog,
create a multi-item join, and use my always true table1 field as the
"Master Folder" and the table2.otherField as the "Detail Folder". But
this seems like a horrible hack. Surely something better is possible?

Mahalo from Hawaii,
Benjamin

Google