SELECT DistintabaseAbbSL.Id_Testa,DistintabaseAbbSL.Cd_TCart,DistintabaseAbbSL.Cd_TColore,
DistintabaseAbbSL.Cd_Stagion,DistintabaseAbbSL.Cd_Flash,DistintabaseAbbSL.Cd_Linea,DistintabaseAbbSL.Cd_Colle,
DistintabaseAbbSL.Cd_Modello,DistintabaseAbbSL.Cd_VarMod,DistintabaseAbbSL.TipoAnaMod,DistintabaseAbbSL.Cd_AnaMod,
DistintabaseAbbSL.Cd_Artico,DistintabaseAbbSL.Cd_varart,DistintabaseAbbSL.Cd_Cart,DistintabaseAbbSL.Cd_Colore,
DistintabaseAbbSL.Cd_Varia,DistintabaseAbbSL.Cd_Lavag,DistintabaseAbbSL.Cd_Drop,DistintabaseAbbSL.Cd_Statura,DistintabaseAbbSL.FlgAnn,
DistintabaseAbbSL.ID
FROM DistintabaseAbbSL
INNER JOIN TestaDistinta
ON DistintabaseAbbSL.Id_Testa = TestaDistinta.Id
AND DistintabaseAbbSL.Cd_TCart = TestaDistinta.Cd_TCart
INNER JOIN DistintaBaseAbb
ON ISNULL(TestaDistinta.cd_stagion, '') = ISNULL(DistintaBaseAbb.cd_stagion, '') AND
ISNULL(TestaDistinta.cd_flash,'') = ISNULL(DistintaBaseAbb.cd_flash, '') AND
ISNULL(TestaDistinta.cd_linea, '') = ISNULL(DistintaBaseAbb.cd_linea, '') AND
ISNULL(TestaDistinta.cd_colle, '') = ISNULL(DistintaBaseAbb.CD_Colle, '') AND
ISNULL(TestaDistinta.cd_modello, '') = ISNULL(DistintaBaseAbb.cd_modello, '') AND
ISNULL(TestaDistinta.cd_varmod, '') = ISNULL(DistintaBaseAbb.Cd_Varia, '') AND
ISNULL(TestaDistinta.Cd_TArtico, '') = ISNULL(DistintaBaseAbb.cd_artico, '') AND
hand wash max at 30° - Do not bleach - Iron at max. 110°C - Gentle dry clean - Do not tumble dry