Blog Pages

SAP ASE (Sybase) - cross join

There is no cross join in SAP ASE (Sybase).

select * 
from FirstTable
cross join LongRunTB
--> Incorrect syntax near 'LongRunTB'.


In order to perform "cross join":

select * 
from FirstTable, LongRunTB
--> works

No comments:

Post a Comment