I am trying to remove a few rows in some of my tables according to an ID from another table (items, purchasedBy).

Here's what I am trying to do..

> 
> DELETE from items.sql where 'PurchasedBy' is 84. DELETE from
>  items\_people where item\_id is (item\_id inside items.sql from the top
>  query) DELETE from items\_places where item\_id is (item\_id inside
>  items.sql from the top query)
> 
> 
> 

so if that makes any sense... here is a sum of what I am trying.. items.sql contains the rows "item\_id" and "purchasedBy". items\_people and items\_places.sql need to have rows deleted according the item\_id where the purchasedby is 84..

I really hope this makes sense cause my head is hurting from just thinking of how to explain it... sorry!