也就是我首先有一个父亲ID然后查询到他同表的子ID.(子ID的某个字段是父ID).然后通过子ID查询在另外一张用户表中查询.属于该子ID的用户(可能是多个).然后再通过用户ID.查询他在另外一张产品表中的产品select * from tb_company where companyPreID = 1select * from tb_companyUser where CompanyUserBelongCompanyID in ()select * from tb_Order where orderCompanyUserID in ()
连起来的SQl语句怎么写
连起来的SQl语句怎么写
CSDN运行的也不是很正常么
select * from tb_Order where orderCompanyUserID in (select 用户ID from tb_companyUser where CompanyUserBelongCompanyID in (select 子ID from tb_company where companyPreID = 1))
select * from 产品表 where 用户id in (
select 用户id from 另一张用户表 as b
left join 用户表 as a
on b.子id = a.子id
where b.父id = 首先有的父id
)
select * from tb_Order where where orderCompanyUserID in ( select CompanyUserBelongCompanyID from
tb_companyUser where CompanyUserBelongCompanyID in ( select companyPreID from tb_company where companyPreID = 1 ))