SELECT WHAB_PRD_LIG_UP.ETAT_LIG_UP, WHAB_PRD_LIG_UP.ID_UP, WHAB_PRD_LIG_UP.QTE_UV_THEO, WHAB_PRD_LIG_UP.QTE_UV_REEL, WHAB_PRD_RCT.PRIX_CONSEILLE, (WHAB_PRD_LIG_UP.QTE_UV_THEO * WHAB_PRD_RCT.PRIX_CONSEILLE) AS [Somme de (THEO * PRIX CONSEILLÉ)], (WHAB_PRD_LIG_UP.QTE_UV_REEL * WHAB_PRD_RCT.PRIX_CONSEILLE) AS [Somme de (REEL * PRIX CONSEILLÉ)], [Somme de (THEO * PRIX CONSEILLÉ)] - [Somme de (REEL * PRIX CONSEILLÉ)] AS [(Somme de THEO - Somme de REEL)]
FROM WHAB_PRD_LIG_UP INNER JOIN WHAB_PRD_RCT ON (WHAB_PRD_RCT.ID_TAILLE = WHAB_PRD_LIG_UP.ID_TAILLE) AND (WHAB_PRD_RCT.ID_COLORIS = WHAB_PRD_LIG_UP.ID_COLORIS) AND (WHAB_PRD_LIG_UP.ID_REF = WHAB_PRD_RCT.ID_REF)
WHERE (((WHAB_PRD_LIG_UP.ETAT_LIG_UP)<=510));