sql多表联合查询,该如何解决

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'

消息 102，级别 15，状态 1，第 2 行
'Goods' 附近有语法错误。

该怎么改啊

[解决办法]
select 
Goods.* from Goods 
inner join GoodsPreviewPic on Goods.goodsNum=GoodsPreviewPic.goodsNum 
inner join GoodsModelPic on Goods.goodsNum=GoodsModelPic.goodsNum 
where Goods.goodsNum='100001'
[解决办法]

SQL 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' 

 

查看更多 下一篇