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 <font color='"Blue"'>MIN(VideoVault.Path)</font> AS Path , <font color='"blue"'>MAX(ColourType.ColourPath)</font> AS ColourPath , VideoVault.EffectType FROM VideoVaultINNER JOIN ColourType ON ColourType.ColourName = VideoVault.EffectType WHERE VideoVault.productCode = 'J72673'GROUP BY VideoVault.EffectType