title: PostgreSQL delete with inner join
body: <pre><code>DELETE B.* 
  FROM   m_productprice B  
         INNER JOIN m_product C ON B.m_product_id = C.m_product_id 
  WHERE  C.upc = '7094' AND B.m_pricelist_version_id = '1000020'
  </code></pre>
  
  <p>i am getting the following error PostgreSQL 8.2.11</p>
  
  <pre><code>ERROR:  syntax error at or near "B"
  LINE 1: DELETE B.* from m_productprice B  INNER JOIN m_product C ON ...
  </code></pre>
  
  <p>i tried giving </p>
  
  <pre><code>DELETE B from m_productprice B  INNER JOIN m_product C ON B....
   ERROR:  syntax error at or near "B"
  </code></pre>
  
  <p>i tried giving</p>
  
  <pre><code>ERROR:  syntax error at or near "INNER"
  LINE 1: DELETE from m_productprice B  INNER JOIN m_product C ON B.m_...
  </code></pre>
  
  <p>what is the problem with my query?</p>