to make a quary for search item?

how i can make a quary that check who got the item x

SELECT name from characters where id = (SELECT characterid from inventoryitem where itemid = 'x')

Use a correlated subquery