v5 Outer join with SQL server

[MarkP]

@Bob Humphrey

Well thanks for all the replies. The answer for me is in the join properties to use (for sql server) the asterisk to denote outer join (just as for the (+) in oracle) This revealed a further issue in that it doesn’t accept an outer join on a pair of views which are themselves products of joins.
I’m having to create different views to solve this but the advice is very welcome for future reference.

Bob,

There is a work around for this - I’ve not used that version of BusinessObjects for a while but there is a solution on here.

Aha, found it:

120×120 10.4 KB

Hi all ! It is all about an outer join problem & SQL ANSI_92 syntax. I looked for messages dealing with this problem, but none has been corresponding (actually, the ones I found were the oppposite of mine …). My problem is that I have complex joins with outer joins melted (one would say “quite ugly” but that’s the ways it is and I have to deal with it to build my universe). Since outer joins are disabled on outerjoins, I have to write it by hand in the join syntax. As a result, when some querr…

Regards,
Mark