34,590
社区成员
发帖
与我相关
我的任务
分享
select date,weight,FaPiaoID from HuoWu
inner join 发票表 on 发票ID=HuoWu.发票ID
or
select date,weight, FaPiaoNo=(select FaPiaoNo from 发票表 where 发票ID=HuoWu.发票ID) from HuoWu
select a.date,a.weight,b.FaPiaoNo as FaPiaoID from HuoWu a left join FaPiao b on a.FaPiaoID = b.FaPiaoID
select a.date,a.weight,b.FaPiaoNo as FaPiaoID from HuoWu a left join FaPiao b on a.FaPiaoID = b.FaPiaoID