AND appro_date = '2015-02-01'
AND appro_date BETWEEN '2015-02-01' AND '2015-02-15'
" // le reste de ta requete... AND appro_date = '" & Tavariable & "'"
cmd.CommandText = "Select UNIQUE s.no_art ,no_art_new ,art_descr ,casier ,pmp ,qte_stock ,qte_res_ate ,qte_res_mag ,genre ,date_min_dlc ,appro_date ,appro_qte ,appro_pa FROM stoc_r S ,laa_r L WHERE S.no_art = L.no_art AND QTE_STOCK > '0' AND appro_date BETWEEN '2015-02-01' AND '2015-02-15' ORDER BY appro_date DESC "
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionWHERE S.no_art = L.no_art
AND QTE_STOCK > '0'
AND appro_date BETWEEN '2015-02-01' AND '2015-02-15'
AND (appro_date = '2015-02-01') OR ( appro_date = '2015-02-15')
AND (appro_date = '2015-02-01') OR (appro_date = '2015-02-15')
AND appro_date = '2015-02-01'
Si ton champ appro_date est déclaré en champ de type Date,, ces chaînes de caractères doivent bien évidemment être transformées en dates.
appro_date = to_date('13/02/2015','DD/MM/YYYY')
comment récupérer les dates d'appro qui sont égal au quantités en stock
dates d'appro qui sont égal au quantités en stock
dates d'appro qui correspondent au quantités en stock
appro_date = to_date('13/02/2015','DD/MM/YYYY')
AND QTE_STOCK > '0' AND appro_date = to_date('" & date1 & "','DD/MM/YYYY') ORDER BY appro_date DESC"