譬如:我存的时候表有俩个仓库ID字段,但查询时需要拿仓库名字
select OutStoreID,InStoreID from a
这时可以用inner join 分别连接两个字段
例:
select b1.StoreName as OutStoreID,b2.StoreName as InStoreID
from A a
inner join B b1 on a.OutStoreID = b1.NID
inner join B b2 on a.InStoreID = b2.NID