朋友进来(找一个朋友)
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 + "%')"