[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2363
  • Last Modified:

FULL OUTER JOIN In BO Universe

How do we apply full Outer join in Universe. The database is SQL Swever 2000.
0
Vijaymadhav
Asked:
Vijaymadhav
1 Solution
 
James0628Commented:
Which version of BO?  I've got 6.5.

 In the JOIN properties there is an "Outer join" check box for each table in the JOIN.  Under the right circumstances, you can check both of those to get a FULL OUTER JOIN.  For some JOIN's here those boxes are greyed out and can't be selected.  I'm not sure why, exactly.  I've never needed to know.  I'm sure that it's because of something in the JOIN.  If they're greyed out for you, you may need to change something in the JOIN in order to make them available.

 Also, there's this from the BO Help file:

 vvvvvvvvvvvvvvvvvvvv

When the universe parameter ANSI 92 is set to YES, you can define a full outer join by selecting the check box for each table in the join. See 'Universe SQL generation parameters' for information on setting the ANSI 92 parameter to activate ANSI 92 support for outer joins in the universe.

 ^^^^^^^^^^^^^^^^^^^^

 So, it appears that you'll also need to have that ANSI 92 parameter set in order to use FULL OUTER JOIN's.  If you can't check both "Outer join" boxes, maybe that's why.

 James
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now