Skip to content
Advertisement

Sql join only 1 row

I want to join the table CustomerAgreementRole with only one row from AgreementRoleGroup, based on ViewPriority. Example: CustomerAgreementRole can have three rows. I only want the joined row where ViewPriority is highest

Current query:

Expected result:

Advertisement

Answer

Made it working with this:

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement