title: DELETE data from a table, joining through two tables
body: <p>I'm working with some rather sensitive data, so I want to be ABSOLUTELY sure I am doing it properly.</p>
  
  <p>I am trying to delete the rows in a table that are associated with another table</p>
  
  <p>The only way to associate the table is to join through two other tables...</p>
  
  <p>here is the exact query:</p>
  
  <pre><code>DELETE tt.Transaction_Amount, tt.Transaction_ID
    FROM ItemTracker_dbo.Transaction_Type tt
    JOIN ItemTracker_dbo.Transaction t ON tt.Transaction_ID = t.Transaction_ID
    JOIN ItemTracker_dbo.Purchase p ON p.Transaction_ID = tt.Transaction_ID
    JOIN ItemTracker_dbo.Item i ON i.Item_ID = p.Item_ID
   WHERE i.Client_ID = 1
  </code></pre>
  
  <p>As you can see, it ain't pretty.</p>
  
  <p>I'm getting an odd error though through the MySQL query browser...</p>
  
  <blockquote>
    <p>Unkown table 'Transaction_Amount' in MULTI DELETE</p>
  </blockquote>
  
  <p>I've tried reading the mysql manual and it seems like this should work to me... any one have any idea's?</p>