Re: Selecting several types

--CELKO-- wrote:

> CREATE TABLE ItemClassifications
> (item_id CHAR(15) NOT NULL
>    REFERENCES Inventory (item_id)
>    ON DELETE CASCADE
>    ON UPDATE CASCADE,
>  item_type INTEGER NOT NULL
>    REFERENCES ItemTypes(item_type)
>    ON UPDATE CASCADE,
>  PRIMARY KEY (item_id, item_type));
> 
>>> Now I want to select all the items of type 100 or 200...<<
> 
>  SELECT DISTINCT item_id
>    FROM Inventory
>   WHERE item_type IN (100, 200);

s/Inventory/ItemClassifications/

This will work if all you need is item_id.  If you need some data from
the Inventory table as well, then use Plamen's or Erland's approach.