Reference another table in SQL odbc query?

[michellepace]

Hi there,

My main "fact" table is created with:

PowerBi Table: My Account Transactions
SELECT AccNumber,Amount, Description
FROM "LedgerTransactions" 
WHERE DDATE >= DATEFROMPARTS(2018,01,01) //Limit Dates

I'd like to create a supporting table which is contrained by the Power bi table 'My Account Transactions'

PowerBi Table: Account Categories
SELECT AccNumber, MainCategory, SubCatergory
FROM "LedgerTransactions" 
WHERE AccNumber IN (select distnct AccNumber from 'My Account Transactions')

Is this at all possible?

[amitchandak]

@michellepace , refer if this can help

https://www.excelguru.ca/blog/2016/04/28/pass-parameters-to-sql-queries/

[lbendlin]

In addition to the warnings in that great article you will also get into trouble with the Great Formula Firewall. There be dragons.