title: SQL Limitations of Microsoft Query in Excel
body: <p>I have using Microsoft Query in Excel 2007 for the past few weeks and have had many cases where the query works fine in SQL Server 2005 but gives irrelevant errors in Microsoft Query. For example I have this case <a href="https://stackoverflow.com/questions/16722509/multipart-identifier-error-in-excel-2007-ms-query-but-not-in-sql-server-2008">Multipart identifier error in Excel 2007 MS Query but not in SQL Server 2008</a> where when I removed the sub queries in <code>SELECT</code> and joined those tables it worked. It doesn't seem to work in this case too. </p>
  
  <p><a href="https://stackoverflow.com/questions/15848015/pass-parameters-to-temp-variables-in-ms-query-on-sql-server-2005-from-excel-2007">Pass parameters to temp variables in MS Query on SQL Server from Excel</a> I guess CTEs don't work in MS Query like <a href="http://social.technet.microsoft.com/Forums/en-US/excel/thread/e8ef2b02-8f34-48d6-b9ff-5ada77e42ac6" rel="nofollow noreferrer">CTE in MS Query Excel 2007</a>. It doesn't work in this case too. <a href="https://stackoverflow.com/questions/16846915/alternative-to-left-join">Alternative to Left Join</a></p>
  
  <p>Can anyone list all the SQL Limitations in Microsoft Query?</p>