SAP Knowledge Base Article - Preview

1196500 - How to generate an INNER JOIN instead of a WHERE clause for the SQL using OLEDB connection to SQL Server 2005

Symptom

How can you generate an INNER JOIN instead of a WHERE clause for the SQL using OLEDB connection to SQL Server 2005?
The aim is to avoid a SQL statement with a WHERE clause:
SELECT *
FROM a, b
WHERE a=b
But rather obtain a SQL statement with an INNER JOIN:
SELECT *
FROM a inner join b on
  ....


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI

Keywords

Inner join OLEDB connection generate , 2107111 , KBA , BI-RA-WBI , Web Intelligence , 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.