SQL using a select query to delete

Question

DELETE * 
FROM foo 
WHERE classid = SELECT classid 
                FROM market_items 
                WHERE steamid = '76561198089201925'

How can we then use this select query to delete all the rows in another table which have a classid as one of the selected class ids.

Please elaborate in your question. Do the query already solve something, are you getting an error or unwanted behaviour? Do steamID have a single classID or multiple classID ? — Juan Carlos Oropeza, Jul 18 '15 at 23:58

score 1 · Accepted Answer · edited Jul 19 '15 at 00:35

1

DELETE 
FROM foo 
where classid in (SELECT classid 
                  from market_items 
                  where steamid='76561198089201925')

edited Jul 19 '15 at 00:35

answered Jul 18 '15 at 23:48

Shreyas Chavan

[you should always use table aliases here to avoid unpleasant surprises](http://stackoverflow.com/q/4594733/73226) – Martin Smith Jul 18 '15 at 23:55

1 Answers1