Hi all,
So I have these tables of items and item-types, and the items can be
of several types:
Items:
ID ; Name
1 ; Item1
2 ; Item2
ItemType:
ID ; Type
100 ; Type1
200 ; Type2
300 ; Type3
Now, to link these 2 I have a "linking" table:
LinkingTable:
ItemID ; ItemTypeID
1 ; 100
1 ; 200
2 ; 100
2 ; 300
Now I want to select all the items of type 100 or 200...
How can I do that without getting a duplicate row of item 1??
Thanks in advance,
Danny
