title: SQL Server "select (a.*) from"
body: <p>What is wrong with:</p>
  
  <pre><code>select count (a.*, b.*)
  from tableA a, tableB b
  where a.x = 'blah'
  and b.x = 'blah'
  </code></pre>
  
  <p>I keep getting the error:</p>
  
  <blockquote>
    <p>Msg 102, Level 15, State 1, Line 1<br>
    Incorrect syntax near '*'.</p>
  </blockquote>
  
  <p>I have a bunch of table names to select from so wanted to use table name aliases? Any help appreciated: I'm not very good with sql.</p>