Deleting with INNER JOIN

Databases
1

So I have this query:

DELETE inventory.* FROM `inventory` INNER JOIN item_instances ON item_instances.ID = inventory.instanceid
			   WHERE inventory.userid = '{$this->info['id']}' AND item_instances.itemid = '$itemid'

This works fine- the only problem is I want it to delete ONE row, but instead it deletes all rows matching the “where”. I tried adding LIMIT 1 but I get mysql error.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘LIMIT 1’ at line 2

2

What difference is there between the row you want to delete and the other rows? Put that unique feature in the WHERE condition.

3

You can’t use LIMIT with a multi-table DELETE. Find another way to identify the rows you want to delete.