I have been humming along with a Cross DB Query connecting two separate SQL DB and a workbook. When I added in three new database table joins I got the following error: The table CompanyName.dbo.TableProperty can not be mapped. I have no idea why this is the case. the Join is a
Left Join (Select alias.Value from Table1 join table 2 on table1.id = table 2.id Where Table1.id = 1) alias on alias.eid = master.eid
I tried just running this query by itself and I get the same error. The table cannot be mapped.