28,390
社区成员
发帖
与我相关
我的任务
分享
dim strsql
strsql="select caipuid,cpname from caipu where cpname like '%"& request("keyword") &"%'"
strsql=strsql & " union "
strsql=strsql & "select caipuid,cpname from caipu where caipuid in (select caipuid from yongliao where yongliao like '%"& request("keyword") &"%')"
strsql=strsql & " union "
strsql=strsql & "select caipuid,cpname from caipu where caipuid in (select caipuid from step表 where stpp_name like '%"& request("keyword") &"%')"
dim strsql
strsql="select caipuid,cpname from caipu where cpname like '%"& request("keyword") &"%'"
strsql=strsql & " union "
strsql=strsql & "select caipuid,cpname from caipu where caipuid in (select caipuid from yongliao where yongliao like '%"& request("keyword") &"%)'"
strsql=strsql & " union "
strsql=strsql & "select caipuid,cpname from caipu where caipuid in (select caipuid from step表 where stpp_name like '%"& request("keyword") &"%)"