yes, i do, but before we get into it, could you give some sample data for each table please
i will be asking you how to decide which values you want for the duplications
if you don’t really care, then you can simply run this –
SELECT [COLOR="Blue"]MIN(VideoVault.Path)[/COLOR] AS Path
, [COLOR="blue"]MAX(ColourType.ColourPath)[/COLOR] AS ColourPath
, VideoVault.EffectType
FROM VideoVault
INNER
JOIN ColourType
ON ColourType.ColourName = VideoVault.EffectType
WHERE VideoVault.productCode = 'J72673'
GROUP
BY VideoVault.EffectType
VideoVault.Path:
assets/video/Fireballspiral/fireballSpiral2.swf
ColourType.ColourPath:
assets/colour/red.png
videovault.EffectType:
Red
The query i posted returns the necessary records except it returns duplicate records for the field ColourType.ColourPath and videovault.EffectType.
For example two records that will display red in the field videovault.EffectType which means ColourType.ColourPath will display the absolute path to the red image button twice.