SELECT [pro altra query (FIS-CAR OK PROV)].NRC, [pro altra query (FIS-CAR OK PROV)].DAT, [pro altra query (FIS-CAR OK PROV)].PRO, [pro altra query (FIS-CAR OK PROV)].VIA, [pro altra query (FIS-CAR OK PROV)].CIT, [pro altra query (FIS-CAR OK PROV)].AREA, [pro altra query (FIS-CAR OK PROV)].TIPOL, PROVENIENZA_NO_DUPLIC.PROVEN, [pro altra query (FIS-CAR OK PROV)].RIB, [pro altra query (FIS-CAR OK PROV)].TEL, [pro altra query (FIS-CAR OK PROV)].NAT, [pro altra query (FIS-CAR OK PROV)].CIN, [pro altra query (FIS-CAR OK PROV)].COF, [pro altra query (FIS-CAR OK PROV)].PRE, [pro altra query (FIS-CAR OK PROV)].COD, [pro altra query (FIS-CAR OK PROV)].LIR AS TOTALE, [pro altra query (FIS-CAR OK PROV)].Id
FROM [pro altra query (FIS-CAR OK PROV)] LEFT JOIN PROVENIENZA_NO_DUPLIC ON [pro altra query (FIS-CAR OK PROV)].CIT = PROVENIENZA_NO_DUPLIC.CIT
WHERE ((([pro altra query (FIS-CAR OK PROV)].DAT) Between #7/1/2017# And #9/30/2017#))
ORDER BY [pro altra query (FIS-CAR OK PROV)].NRC, [pro altra query (FIS-CAR OK PROV)].DAT, [pro altra query (FIS-CAR OK PROV)].Id;
|