Error: Incorrect syntax near the keyword 'and'. [20018] (severity 15) [ SELECT SEdition.numSEdition, Supports.Titre, SEdition.numVille, Adresses_Villes.Ville
            from
            Adresses_Villes
            inner join
            SEdition
            on SEdition.numVille=Adresses_Villes.NumVille
            INNER JOIN
            NB_Programmes_AU_detail
            ON SEdition.numSEdition = NB_Programmes_AU_detail.ProgD_SEdition
            inner join
            Supports
            on Supports.CodeSupport = SEdition.CodeSupport
            where   (Supports.NumPays = 1) 
            AND (SEdition.NumMedia = 5) 
            and NB_Programmes_AU_detail.NumProg = 
            and (NB_Programmes_AU_detail.ProgD_DateDiff 
            BETWEEN     
            CONVERT(DATETIME, '', 102) 
            AND CONVERT(DATETIME, '', 102))
            group by SEdition.numSEdition, Supports.Titre,SEdition.numVille,Adresses_Villes.Ville]