title: DB2 Delete With Inner Join
body: <p>I have a query like this : </p>
  
  <pre><code>DELETE FROM db2inst1.REPORTER_STATUS INNER JOIN REPORTER_DETAILS 
  ON REPORTER_STATUS.SERVERSERIAL = REPORTER_DETAILS.SERVERSERIAL 
  AND year(REPORTER_STATUS.FIRSTOCCURRENCE)=2011 AND 
  month(REPORTER_STATUS.FIRSTOCCURRENCE)=12 AND 
  day(REPORTER_STATUS.FIRSTOCCURRENCE)=12
  </code></pre>
  
  <p>I want to run a query like tihs but it gives me error. How can i run a query like that ?</p>