Question

两个条件的SQL语句，两个条件分别写能显示数据，将两个条件合在一起写，就显示不出来，帮帮忙~~~

第一个：sql="select * from Sale where kfcode="&request("selectkfname")&"“
第二个：sql="select * from Sale where Salesdate between "&request("ksdate")&" and "&request("enddate") &"”
请问两个条件和在一起写怎么写

Answer 1

sql="select * from (select * from Sale where Salesdate between "&request("ksdate")&" and "&request("enddate") & ) where kfcode="&request("selectkfname")&"“

Answer 2

sql="select * from Sale where kfcode="&request("selectkfname")&" and (Salesdate between "&request("ksdate")&" and "&request("enddate") &")"