Forum Discussion

sdayringer's avatar
sdayringer
New Contributor III
2 years ago

Extract Account's Assigned Plug Account via SQL

Hello, How can I call an account's assigned plug account via SQL? I able to get the PlugAcct DecimalValue, but need help with the syntax to return the account member name instead of the ID... SEL...
Reports
  • JackLacava's avatar
    JackLacava
    2 years ago

    You're joining on the wrong thing in the PlugAccount subquery. Should be:

    LEFT JOIN Member PA ON MP.DecimalValue = PA.MemberId

     

JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

You're joining on the wrong thing in the PlugAccount subquery. Should be:

LEFT JOIN Member PA ON MP.DecimalValue = PA.MemberId