Forum Discussion
Advanced ODBC Query - Pulling through a Summarized/Pre-Merged Column
Hi all, I'm posting as I am trying to figure out how I can pull a summarized column through from an ODBC table using an Advanced ODBC query. Why I want to do this: 1. The table that I'm qu...
Not clear what you are describing here. Is InMaster part of the InTrans table and you forgot to include it in the Select statement?
lbendlin InMaster is a separate table to InTrans but it's stored in the server as an expandable column in InTrans.
I know this because if I import the entire table I can see the column and click a drop down to select the columns from InMaster that I want to expand for.
It looks exactly the same as you'd expect it to you if you did a merge in Power Query between two tables but I just can't pull it through using the SQL query.
The only thing I've been able to do to get it to kind of work is do an inner join in the SQL and state exactly which column from InMaster I want.