1 2 3 4 5 6 7 8 9 10
|
SELECT dbo.Article.art_base, dbo.Article.art_bar, dbo.Bareme.bar_val, dbo.TypeJour.tj_val, dbo.Article.art_controle, dbo.Controle.ctrl_val, dbo.Article.art_modif,
dbo.Article.art_artcateg, dbo.Article.art_tj, dbo.Article.art_fixe1, dbo.Article.art_categ, dbo.Article.art_date, dbo.Article.art_heure, dbo.Article.art_ddeur,
dbo.Article.art_fixe2, dbo.Article.art_dde, dbo.Article.art_fixe3, dbo.Article.art_duree, dbo.Article.art_cout, dbo.Article.art_ccd, dbo.Article.art_typecom,
dbo.Article.art_fixe4
FROM dbo.Article
INNER JOIN dbo.Bareme ON dbo.Article.art_bar = dbo.Bareme.bar_id
INNER JOIN dbo.TypeJour ON dbo.Article.art_tj = dbo.TypeJour.tj_id
INNER JOIN dbo.Controle ON dbo.Article.art_controle = dbo.Controle.ctrl_id
WHERE .... |
Partager