Query not displaying data in Excel

[Clan57]

Hi,

I'm trying to query a few tables in our SQL server directly from excel so that the data is imported whenever I hit refresh.

I used "Get External Data From Microsoft Query" so that I could query the server without returning the entire results (probably a few hundred thousand records when my query would probably return about 1000).

However,

When I insert the query in Microsoft query, it displays the results of the query with no problem, then, when I choose to return the data to a cell in Excel, the query executes but the ONLY thing displayed in the worksheet is "Query from [SQL Server Name]".

My query contains a LEFT JOIN which my googling has so far indicated may be part of the problem, but no solution yet..

 

[Clan57]

Query looks something like this - I've added the { oj } and changed LEFT JOIN to LEFT OUTER JOIN based on other posts I've found - but no luck yet.

USE Database_Name;

SELECT A.Id
, A.Name
, B.State
, B.Country


FROM {oj TableA A
LEFT OUTER JOIN TableB B ON  A.Id = B.Id}


WHERE 
A.Name LIKE '%test%'

 

[Clan57]

Bump