1 2 3 4 5
| SELECT ARTICLES.ean_article, ARTICLES.marque_article, ARTICLES.designation_article, ARTICLES.poids_contenance_article, ARTICLES.unite_article, ARTICLES.pcb_article, ARTICLES.colis_couche, ARTICLES.couche_pal, [TARIF VENTE].TVA, [TARIF VENTE].pv_base_2019, [TARIF VENTE].Accises_2019, [TARIF VENTE].pv_base_2019_accises, ARTICLES.sous_gamme_article, ARTICLES.type_tarif, ARTICLES.incontournable
FROM ARTICLES INNER JOIN [TARIF VENTE] ON ARTICLES.ref_article = [TARIF VENTE].ref_article WHERE ARTICLES.incontournable <>""
UNION
SELECT ARTICLES.ean_article, ARTICLES.marque_article, ARTICLES.designation_article, ARTICLES.poids_contenance_article, ARTICLES.unite_article, ARTICLES.pcb_article, ARTICLES.colis_couche, ARTICLES.couche_pal, [TARIF VENTE].TVA, [TARIF VENTE].pv_base_2019, [TARIF VENTE].Accises_2019, [TARIF VENTE].pv_base_2019_accises, ARTICLES.sous_gamme_article, ARTICLES.type_tarif, ARTICLES.incontournable
FROM ARTICLES INNER JOIN [TARIF VENTE] ON ARTICLES.ref_article = [TARIF VENTE].ref_article; |
Partager