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 code
select     Goods.* from Goods     inner join GoodsPreviewPic     on Goods.goodsNum=GoodsPreviewPic.goodsNum     inner join GoodsModelPic         on Goods.goodsNum=GoodsModelPic.goodsNum     where Goods.goodsNum='100001'