sql多表联合查询解决方法

2012-09-25

sql多表联合查询这句查询语句要怎么改SQL codeselectGoods.* from Goodsinner join GoodsPreviewPic.* fro

sql多表联合查询
这句查询语句要怎么改

SQL code

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'

[解决办法]

C# code

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'
[解决办法]
SQL codeselect     Goods.* from Goods     inner join GoodsPreviewPic     on Goods.goodsNum=GoodsPreviewPic.goodsNum     inner join GoodsModelPic         on Goods.goodsNum=GoodsModelPic.goodsNum     where Goods.goodsNum='100001'