how can i use WHERE and BETWEEN clause simultaneously..?
my tables details is below. expid expdate exprs expdetails expfor_id
i want to find out record between two dates whose expfor_id = 1
my query is
SELECT * FROM
_exp_date BETWEEN ('2009-07-01' AND '2011-07-30') AND
_exp_for_id = 1
but it dose not give any result..
sir, give me repply soon.. thank you by kalpesh
Please go through the following link: