Skip to Content
Former Member
Dec 16, 2015 at 01:42 PM

HANA SQL Join only first entry of another table


Hi Folks,

I got the requirement to join from another table only the first matching entry (as the second table contains several records that match the criteria)

Something similar like described in the above link.

However, when I implement the inner join with the WHERE condition and select top 1 it complains thatTOP cannot be used in subquery.

Does anybody know how to solve this?

Cover the requirement differently?

Thanks for all replies in advance.

Best regards,