by "Plamen Ratchev" <Plamen@[EMAIL PROTECTED]
>
May 7, 2008 at 10:17 AM
You can use DISTINCT:
SELECT DISTINCT I.item_id, I.item_name
FROM Items AS I
JOIN ItemTypes AS T
ON I.item_id = T.item_id
WHERE T.item_type_id IN (100, 200);
HTH,
Plamen Ratchev
http://www.SQLStudio.com
