从三张表中取出一个字段

select *from(select * fromb inner join c on b.零售单号=c.零售单号)xinner join a on x.会员id=a.会员id
select khID ,hykID from c join b on (b.lsdH=c.lsdH) join a on (a.khID=b.KHID)客户IDkhID零售单号lsdH会员卡号hykID这样就关联了，要是想查询客户ID或者会员卡ID就可以 select * from (select khID ,hykID from c joinb on (b.lsdH=c.lsdH) join a on (a.khID=b.KHID) ) D想怎么查究怎么查。

文章标签：

来自：idkh

本文链接：https://www.u1e.cn/baike/a/d2d69d81a4084b530ad50258 [复制]