1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SELECT DISTINCT GRC.Name AS Cate, GES.Name AS St, GF.Description AS Fu,
FEO.UIN, GEF.Mnemonic, FEO.CK AS cKy, GEF.Name,
GDR.Name AS DN, FEO.OD, FEO.EOId,
Result.Name AS RVN, Result.Value AS RVV
FROM FEO
INNER JOIN GEF
ON FEO.PN = GEF.PN AND
FEO.CK = GEF.CK
INNER JOIN GF
ON GEF.PN = GF.PN AND
GEF.FID = GF.ID AND
GEF.PN = GF.PN AND --> redondant !!!
GEF.FID = GF.ID --> redondant !!!
INNER JOIN GES
ON GEF.PN = GES.PN AND
GEF.SN = GES.Name AND
GEF.PN = GES.PN AND --> redondant !!!
GEF.SN = GES.Name --> redondant !!!
OUTER APPLY dbo.MaFonction(FEO.EOId) as Result
UNION
SELECT |
Partager