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

HANA SQL Join only first entry of another table

2794 Views

http://stackoverflow.com/questions/6792285/sql-distinct-based-on-only-some-columns

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,

Axel