Error in Query: SELECT h.LogID, h.GeneralName, h.Image FROM Current_Heirachy h WHERE `Level` = 3 AND ParentName = (SELECT ItemName FROM Current_Heirachy WHERE GeneralName = 'Tool Accessories' AND LogID IN (2)) AND LogID IN (2) ORDER BY Display ASC; Subquery returns more than 1 row