查询:货物1001的出货库和区
select w.Name as '出货库', r.Name as '出货区' from RegionWarehouseLink rwl
inner join Warehouse w on w.Wid = rwhl.Wid
inner join Region r on r.Rid = rwhl.Rid
where rwl.RwlId in
(select rwlId from GoodRegionWarehouseLink where
gid in (select gid from good where name='1001')
and status = 1
)