1 2
| SELECT T_Action.IDAction, T_Action.RefAG, T_AG.AGShort, T_Action.ForeseenDate, T_Action.RefThemeStrat, T_Theme_Strat.ThemeStratTitle, T_Action.RefTarget, [T-Target].TargetTitle, T_Action.RefThemeAG, T_Theme_AG.ThemeAGTitle, T_Action.RefTargetAG, T_Target_AG.TargetAGTitle, T_Action.Description, T_Action.Message, T_Action.ExtInternet, T_Action.ExtSocialMedia, T_Action.ExtBrochure, T_Action.ExtAffichage, T_Action.ExtEcrans, T_Action.ExtPublicite, T_Action.ExtCommuniquePresse, T_Action.ExtConférencePresse, T_Action.ExtCourrier, T_Action.ExtMassMailing, T_Action.ExtSalon, T_Action.IntIntranet, T_Action.IntSocialMedia, T_Action.IntFininfoPapier, T_Action.IntFininfoElectronique, T_Action.IntMNL, T_Action.IntBrochure, T_Action.IntSeminaire, T_Action.IntAffichage, T_Action.IntCourrier, T_Action.IntMassMailing, T_Action.ChannelComment, T_Action.DependanceCSC, T_Action.DependanceAutre, T_Action.Budget, T_Action.Comments, T_Action.Contact, T_Action.Status, T_Action.Postponed, T_Action.Delayed, T_Action.Evaluation
FROM [T-Target] RIGHT JOIN (T_Theme_Strat RIGHT JOIN (T_Theme_AG RIGHT JOIN (T_Target_AG RIGHT JOIN (T_AG RIGHT JOIN T_Action ON T_AG.IDAG = T_Action.RefAG) ON T_Target_AG.IDTargetAG = T_Action.RefTargetAG) ON T_Theme_AG.IDThemeAG = T_Action.RefThemeAG) ON T_Theme_Strat.IDThemeStrat = T_Action.RefThemeStrat) ON [T-Target].IDTarget = T_Action.RefTarget |
Partager