CODEWITHSUNDEEP
sqlhana
DB_Dentist
DB_Dentist

Reputation: 31

Do we have any CROSS APPLY feature in SAP HANA?

How can we join a table and a function in SAP HANA SQL, I checked but CROSS Apply does not work in HANA as in SQL Server.

Does anyone with HANA background have any solution to this?

How can SAP miss these important features like this?

Upvotes: 0

Views: 1876

Answers (1)

Lars Br.
Lars Br.

Reputation: 10396

CROSS JOIN is a SQL standard function and HANA implements it in a compliant way. Current HANA version support LATERAL JOIN which is equivalent to CROSS APPLY if I understand that correctly.

Upvotes: 1

Related Questions