Lookup Columns not behaving properly on Joins and / or Query Tables
I am using the Report Client. exportDataUsingSQL method call.
The SQL I am using is joining a few tables, one of the columns involved in the JOIN clause is a Lookup Column.
This JOIN is now failing on that column.
It is a relatively simple join
Select ....
From Table A a
JOIN Table B b on a.col1 = b.col2
In this case, b.col2 is actually a lookup column, but I am getting an error stating that "col2" is an invalid Column.
Using the create query table feature, I try "Select * from B" ...and the "col2" is not part of the result set.
Please advise.
Note I have shared my database with Support.
Cheers,
Tyler
PS:
This is impacting several of my database, so it is not isolated to a single database.