Subject GSG087. TIB_RadioGroup/Making IB_RadioGroup More Data-Aware
Author Raymond Kennington
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

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