How to join MainAccount to MainAccountCategory?

Like (0) Share

Report

Posted on 18 May 2022 14:34:04 by agneum

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.

All responses (5)

Answers (1)

Verified answer

abdultp 867 on 18 May 2022 at 15:26:50

Like (1)

Report

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