一个商品有很多图片,我差出来了商品下的所有图片,我只想要商品的第一个图片?请问怎么解决?select Products.PD_ID,PD_name,PD_etprice,PD_saleprice,PT_bigurl
from Products,ProductPicture,Pictures
where Products.PD_ID = ProductPicture.PD_ID and ProductPicture.PT_ID = Pictures.PT_ID and CHARINDEX(@Tag ,PD_tags) > 0
from Products,ProductPicture,Pictures
where Products.PD_ID = ProductPicture.PD_ID and ProductPicture.PT_ID = Pictures.PT_ID and CHARINDEX(@Tag ,PD_tags) > 0
select ROW_NUMBER() OVER(order by 用户编码 desc) as a from tableName
where a=1
from Products,ProductPicture,Pictures
where Products.PD_ID = ProductPicture.PD_ID and ProductPicture.PT_ID = Pictures.PT_ID and CHARINDEX(@Tag ,PD_tags) > 0 order by ProductPicture.PT_ID
select
ROW_NUMBER() OVER(order by PD_ID ) as a
Products.PD_ID,
PD_name,
PD_etprice,
PD_saleprice,
PT_bigurl from Products,ProductPicture,Pictures
where Products.PD_ID = ProductPicture.PD_ID
and ProductPicture.PT_ID = Pictures.PT_ID
and CHARINDEX(@Tag ,PD_tags) > 0
and a=1
为什么不试试我的呢? 我才给你思想了啊?