Member Avatar for Aakashdata

How can I create different types of joins in SAP HANA?

  • 2 Contributors
  • 1 Reply
  • 328 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by alan.davies
Member Avatar for alan.davies

JOINS in SAP HANA, from what I've read, are pretty much standard SQL affairs...

SELECT [alias1.field1, alias1.field2, alias2.fieldA...] FROM [table1] AS [alias1] INNER JOIN [table2] AS [alias2] ON [alias1.joinfield] = [alias2.joinfield]

BTW - don't put in the square brackets - they're just there to denote placeholders / examples!

Edited by alan.davies
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.