SQL一个表中多个字段对应另一个表的同一字段

譬如：我存的时候表有俩个仓库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