select a.goods_id,b.goods_name,a.supplier,b.brand,b.size,c.level,a.warehouse_id
from inventory a,(select m.goods_id,goods_name,n.brand,p.size
from goods m,brand n,size p
where m.goods_brand=n.id
and m.goods_size=p.id) b,level c
where a.goods_id=b.goods_id
and a.goods_level=c.id
;