请帮我看一下,这句SQL语句错误在哪里?谢谢了!
SQL语句如下:
SQL = "Select * From one_money where sflx like '"&searchlb&"' and kemu like '"&searchkemu&"' and (datediff(d,"&searchbegindate&",kmdate)<=0 and datediff(d,kmdate,"&searchenddate&")<= 0) and pr_id in (select pr_id from pr_basicinfo where (cmanager like '"&realname&"' or pmanager like '"&realname&"') and proarea like '"&searcharea&"') Order By kmdate"
数据库中存在符合条件的记录,但是查询不出来!