SAP Knowledge Base Article - Preview

1320617 - Outer join with SQL 2005 database does not generate the correct SQL in reports using Business objects XI 3.1


  • Query does not allow to reverse the direction of the outer join.
  • In Business Objeects XI Release 2 the SQL syntax appeared as "TABLE1.OBJECT1=*TABLE2.OBJECT1", while in XI 3.1 it reads it as "TABLE1.OBJECT1=TABLE2.OBJECT1"



SAP BusinessObjects Enterprise XI 3.1


BOXIR3, BOXI 3.1, jointure, externe, wrong, , KBA , BI , Business intelligence solutions , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.