SAP Knowledge Base Article - Preview

3677855 - How to code a CROSS JOIN? - SAP ASE

Symptom

  • A CROSS JOIN of two tables returns a join of every row of the first with every row from the second table
  • The result is also called a Cartesian Product of the two tables
  • The TSQL language does not have an explicit CROSS JOIN operator
  • How to implement a query that performs a CROSS JOIN?


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) all versions

Product

SAP Adaptive Server Enterprise all versions

Keywords


cross join, cartesian product, tsql cross join, sap ase cross join, sybase ase cross join, sql join types, join without condition, ansi join syntax, database cross join, sql cartesian product, tsql join examples, cross join implementation, sql join operator, cross join query , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.