right outer/full outer joins

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2411038212

February 12, 2007, 12:24 PM

right outer/full outer joins

Can you do a right outer or full outer join in WebFOCUS? Thanks for your help!

February 12, 2007, 01:26 PM

newtofocus

To the best of my knowlded ou can do a right outer join, but not a full outer join.

WF7.1.4 Prod/Test, MRE, self serve, DM

February 12, 2007, 02:06 PM

BlueZone

If your datasources are relational, you might as well use SQL-passthru to do JOINs anyway you want them to be.

The closest option in FOCUS would be to use the MATCH syntax.

-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !!

February 13, 2007, 10:24 AM

Thanks for your replies. The MATCH functionality worked great.

February 14, 2007, 03:39 PM

<Emily Duensing>

I believe in 7.6 you can do both right outer joins and full outer joins in the join tool. You get to the join properties and there is a drop down list where you can select the different options and the venn diagram will show you the result.