1 2 3 4 5 6 7 8 9
| Et si nécessaire, voici le code de la vue
SELECT mediaDef.ID, mediaType.TechnicalName, mediaDef.Actif, mediaDef.HRK, mediaDef.Name, YR.ImagesRef.ImgName, YR.ImagesRef.ImageType
FROM dbo.MediaDef AS mediaDef INNER JOIN
dbo.MediaType AS mediaType ON mediaType.ID = mediaDef.MediaType AND mediaType.TechnicalName <> 'LAPTOP' LEFT OUTER JOIN
YR.ImagesRef ON mediaDef.ID = YR.ImagesRef.MediaDef
UNION
SELECT [ProdID], 'LAPTOP' AS [TechnicalName], 1 AS Actif, HRK, [FullName] AS Name, NULL AS ImgName, 0 AS ImageType
FROM [Touch-DEV].[dbo].[LaptopModels] |
Partager