Notifications
Announcements
No record found.
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.MAINACCOUNTCATEGORYBut mainaccountcategory column is not in MainAccount table.
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
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?
I think I will use this "AE" , I assume this is in Visual Studio? Can you please clarify?
Application Explorer in VS
Wonderful, thank you!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 449 Super User 2025 Season 2
Martin Dráb 422 Most Valuable Professional
BillurSamdancioglu 239 Most Valuable Professional
