朋友进来（找一个朋友）

[kangqing]

sql="select company.*,ordgood.* from company,ordgood where (select ord.* company.* from ord,company where ord.ord_company=company.company_id) and (select ord.*,ordgood.* from ord,ordgood where ord.ord_on=ordgood.ordgood_ord_on) and isnull(company.company_name '') like '%" + company_name + "%' and (isnull(company.company_man1 '') like '%" + company_man + "%' or isnull(company.company_man2 '') like '%" + company_man + "%' or isnull(company.company_owner '') like '%" + company_man + "%') and (isnull(company.company_tel1 '') like '%" + company_tel + "%' or isnull(company.company_mobile1 '') like '%" + company_tel + "%' or isnull(company.company_tel2 '') like '%" + company_tel + "%' or isnull(company.company_mobile2 '') like '%" + company_tel + "%') and isnull(good.good_code like '') '%" + good_code + "%' and isnull(good.good_name '') like '%" + good_name + "%')"

[txlicenhe]

1:怎么了？好象没问题啊。
2:你找哪位，我帮你叫他。

[weichenggao]

是我，帮你定！

[weichenggao]

关于楼主的问题我已私下和楼主联系，并得到解决，谢谢！

[txlicenhe]

建议and ,or 太多时加一些括号。
sql=
"select company.*,ordgood.* from company,ordgood where
(select ord.* company.* from ord,company where ord.ord_company=company.company_id)
and (select ord.*,ordgood.* from ord,ordgood where ord.ord_on=ordgood.ordgood_ord_on)
and isnull(company.company_name '') like '%" + company_name + "%'
and ( (isnull(company.company_man1 '') like '%" + company_man + "%'
or isnull(company.company_man2 '') like '%" + company_man + "%'
or isnull(company.company_owner '') like '%" + company_man + "%') )
and ( (isnull(company.company_tel1 '') like '%" + company_tel + "%'
or isnull(company.company_mobile1 '') like '%" + company_tel + "%'
or isnull(company.company_tel2 '') like '%" + company_tel + "%'
or isnull(company.company_mobile2 '') like '%" + company_tel + "%') )
and isnull(good.good_code like '') '%" + good_code + "%'
and isnull(good.good_name '') like '%" + good_name + "%')"

[yujohny]

sql='select company.*,ordgood.* from company,ordgood
where (select ord.* company.* from ord,company
where ord.ord_company=company.company_id) and
(select ord.*,ordgood.* from ord,ordgood
where ord.ord_on=ordgood.ordgood_ord_on) and
isnull(company.company_name, '''') like ''%'' + company_name + ''%''
and (isnull(company.company_man1, '''') like ''%''
+ company_man +''%'' or isnull(company.company_man2, '''') like ''%''
+ company_man + ''%'' or isnull(company.company_owner,'''') like ''%''
+ company_man + ''%'') and (isnull(company.company_tel1, '''')
like ''%'' + company_tel + ''%'' or isnull(company.company_mobile1, '''')
like ''%'' + company_tel + ''%'' or isnull(company.company_tel2, '''') like ''%'' + company_tel + ''%'' or isnull(company.company_mobile2, '') like ''%'' + company_tel + ''%'') and isnull(good.good_code,'') ''%'' + good_code + ''%'' and isnull(good.good_name '''') like ''%''+ good_name + ''%'')'

[zjcxc]

既然已经解决,就将解决的贴出来吧.