SELECT DISTINCT ProductColor.ColorCode, Color.Color
FROM ProductColor JOIN Color
ON Color.ColorCode=ProductColor.ColorCode
WHERE ProductColor.ProductID=:ProductID

In the example, why does the join query request DISTINCT rows? (Won't they be distinct
anyway?)

Is it because primary keys haven't been defined for the tables?
--
Raymond Kennington
Programming Solutions
W2W Team B