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" SQL = "Select * From one_money w
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" SQL = "Select * From one_money w
