title: Query too long in .NET 3.5 and SQL Compact 3.5
body: <p>this is a rather pathetic problem:</p>
  
  <p>In Visual Basic 2008 Express with SQL Server Compact 3.5 and the Usual DataSet / TableAdapters, My Query is too long:</p>
  
  <p>Changing the names, it is a query like this:</p>
  
  <pre><code>SELECT Table1.*, Table3.* 
  FROM Table1 
      INNER JOIN Table2 
          ON Table1.ID = Table2.T1ID 
      INNER JOIN Table3 
          ON Table2.T3ID = Table3.PK
  </code></pre>
  
  <p>Problem is, Table1 and Table3 have around 10 and 5 columns each, with rather descriptive names, and The Table adapter is insistent on writing all the columns out and therefore hacks off my command. (It won't take * 's, it always says it can't find the column Table1.* )</p>
  
  <p>Is there a way around this?</p>