Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / How to join MainAccoun...
Finance forum
Answered

How to join MainAccount to MainAccountCategory?

Posted on by 150

Hi,

Is there any easy way to join the two tables MainAccount and MainAccountCategory? 
I am looking for a join, something like dbo.MainAccountStaging.MAINACCOUNTCATEGORY = dbo.MainAccountCategoryStaging.MAINACCOUNTCATEGORY
But mainaccountcategory column is not in MainAccount table.

  • agneum Profile Picture
    agneum 150 on at
    RE: How to join MainAccount to MainAccountCategory?

    Wonderful, thank you!

  • Suggested answer
    abdultp Profile Picture
    abdultp 865 on at
    RE: How to join MainAccount to MainAccountCategory?

    Application Explorer in VS

    pastedimage1652889016686v1.png

  • agneum Profile Picture
    agneum 150 on at
    RE: How to join MainAccount to MainAccountCategory?

    I think I will use this "AE" , I assume this is in Visual Studio? Can you please clarify?

  • agneum Profile Picture
    agneum 150 on at
    RE: How to join MainAccount to MainAccountCategory?

    Thank you. I missed that column for some reason. It wasn't shown in the table browser

    mi=SysTableBrowser&TableName=MainAccount

    Do you know why this might be?

  • Verified answer
    abdultp Profile Picture
    abdultp 865 on at
    RE: How to join MainAccount to MainAccountCategory?

    Hi Agneum,

    You can relate mainaccount & mainaccountcategory tables using AccountCategoryRef field. For SQL you can use

    dbo.MAINACCOUNTCATEGORY.ACCOUNTCATEGORYREF = dbo.MAINACCOUNT.ACCOUNTCATEGORYREF

    If you need to know how tables are related, you can check it in AE in the 'relations' section of table

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans