1 2 3 4
|
SELECT IND_V_LIST_GOOD.DIC_GOOD_LINE_ID, IND_V_LIST_GOOD.DIC_GOOD_MODEL_ID, IND_V_GOOD_DESC.DES_FREE_DESCRIPTION, IND_V_GOOD_DESC.DES_LONG_DESCRIPTION, IND_V_GOOD_DESC.DES_SHORT_DESCRIPTION, IND_V_LIST_GOOD.GOO_MAJOR_REFERENCE, IND_V_LIST_GOOD.GCO_GOOD_ID, PC_LANG.PC_LANG_ID, PC_LANG.LANG_DESC
FROM PC_LANG INNER JOIN (IND_V_LIST_GOOD INNER JOIN IND_V_GOOD_DESC ON IND_V_LIST_GOOD.GCO_GOOD_ID = IND_V_GOOD_DESC.GCO_GOOD_ID) ON PC_LANG.PC_LANG_ID = IND_V_GOOD_DESC.PC_LANG_ID
WHERE (((IND_V_LIST_GOOD.GCO_GOOD_ID)=[Formulaires]![test]![REFERENCE]) AND ((PC_LANG.PC_LANG_ID)=[Formulaires]![test]![LANGUE])); |
Partager