title: Delete rows from multiple tables using a single query (SQL Express 2005) with a WHERE condition
body: <p>This is the query I'm using:</p>
  
  <pre><code> DELETE TB1.*, TB2.*
     FROM TB1
          INNER JOIN TB2 ON TB1.PersonID = TB2.PersonID 
    WHERE (TB1.PersonID)='2'
  </code></pre>
  
  <p>It's working fine in MS Access but getting error (Incorrect syntax near ','.) in SQL Server Express 2005. </p>
  
  <p>How to solve it? Please help.</p>