日期:2014-05-17 浏览次数:20592 次
select
Goods.* from Goods
inner join GoodsPreviewPic.* from GoodsPreviewPic
on Goods.goodsNum=GoodsPreviewPic.goodsNum
inner join GoodsModelPic.*
from GoodsModelPic on Goods.goodsNum=GoodsModelPic.goodsNum
where Goods.goodsNum='100001'
select
Goods.* from Goods
inner join (select GoodsPreviewPic.* from GoodsPreviewPic )GoodsPreviewPic
on Goods.goodsNum=GoodsPreviewPic.goodsNum
inner join (select GoodsModelPic.*
from GoodsModelPic)GoodsModelPic on Goods.goodsNum=GoodsModelPic.goodsNum
where Goods.goodsNum='100001'