Derived Table

[sduplan]

From Tables A, B, and C, I need to generate Table D, and use it to perform an left outer join on Table E.
How can this be done? In Designer? How?

Thanks

 

[jimbopalmer]

in SqlPlus you could make D a view of A, B and C. In Designer you can make outer joins either d.mykey (+) = e.mykey or click check boxes for outer joins The one thing you can't give for your heart's desire is your heart. - Lois McMaster Bujold

 

[sduplan]

Thanks for your reply jimbopalmer.
However, is it possible to implement this purely with a universe, without getting down to SQL coding?

 

[sduplan]

I tried the view approach and it worked fine. Thanks.