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 ;
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
;
http://bbs.csdn.net/topics/390682490?page=1#post-396479791