i'm obviously not looing at this command in the right way.
basically if i were to have the following tables
so in this case product 2 has the types 3 and 4 associated with it i would like to pull out
i.e. all the types that are not associted with this product. i'm using the EXCEPT sql command but its not working. is this the correct command to be looking at or should i be doing it differently?
SELECT typeID FROM type EXCEPT SELECT typeID FROM productType WHERE productID=198 ORDER BY productType.productID;