select company.name,good.name from company,good
where good_id in(
select ord_good_on from ord_good where ord_good_ord in(
select ord_id from ord where ord_company in(
select company_id from company where name= [输入的公司名称]) ) )
and company.name = [输入的公司名称]
select company.name,good.name from company,good
where good_id in(
select ord_good_on from ord_good where ord_good_ord in(
select ord_id from ord where ord_company in(
select company_id from company where name= [输入的公司名称]) ) )
你们让我贴的不要怪我
"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 + "%')"
select D.goodname
from company A inner join ord B on B.ord_company=A.company_id
inner join ord_good C on C.ord_good_ord=B.ord_id
inner join good D on D.good_id=C.ord_good_on
where A.companyname='某某某'
select company.name,good.name from ord
left outer join ord_good on ord.id=ord_good.ord
left outer join company on ord.company = company.id
left outer join good on ord_good.on=good.id
where company.name= [输入的公司名称]
select c.name,g.name
from company c join ord o
on o.ord_company=c.company_id
join good g
on o.ord_good_on=g.good_id
join ord_good oo
on oo.ord_good_ord=o.ord_id
where c.name='公司名称'