Sub query IN statement

[Lee Marshall]

Very confused why the following is not working:

SELECT A_ID, concat_ws(' ', concat_ws(' ', a.A_Brand, a.A_Model), a.A_Name) as product
FROM vm_accessory a WHERE a.A_ID in (
SELECT AccessoryID FROM vm_access_inter
GROUP BY AccessoryID)
ORDER BY 2

but this does

SELECT A_ID, concat_ws(' ', concat_ws(' ', a.A_Brand, a.A_Model), a.A_Name) as product
FROM vm_accessory a WHERE a.A_ID in (
6, 9)
ORDER BY 2

If I run just the subquery by itself I get 6 and 9 and no error.

Very odd.

THanks for any tips in advance.