title: SQlite delete inner join
body: <p>I have read alot of other answers but cannot get this working!.</p>
  
  <pre><code>select * from invTypes
  inner join invGroups on invtypes.groupID = invgroups.groupID
  where invGroups.categoryID = 25;
  </code></pre>
  
  <p>I simply want to delete the record from invTypes if the category ID matches to 25</p>
  
  <p>Would be very grateful of assistance</p>
  
  <p>I have already tried:</p>
  
  <pre><code>delete from invTypes
  inner join invGroups on invtypes.groupID = invgroups.groupID
  where invGroups.categoryID = 25;
  </code></pre>
  
  <p>Gives error:
  near "inner": syntax error: </p>
  
  <pre><code>DELETE FROM invTypes
  WHERE groupID in ( SELECT groupID FROM invGroups INNER JOIN invTypes ON (invGroups.groupID = invTypes.groupID) 
  WHERE invGroups.categoryID = 25);
  </code></pre>
  
  <p>Gives:
  ambiguous column name: groupID: DELETE FROM invTypes
  WHERE groupID in ( SELECT groupID FROM invGroups INNER JOIN invTypes ON (invGroups.categoryID = invTypes.categoryID) WHERE invGroups.categoryID = 25);</p>