SQL商品对应多个图片的问题

[saxok]

一个商品有很多图片，我差出来了商品下的所有图片，我只想要商品的第一个图片？请问怎么解决?

select Products.PD_ID,PD_name,PD_marketprice,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

[Iovswety]

top 1 ???

[by_封爱]

select  ROW_NUMBER() OVER(order by 用户编码 desc)  as a from tableName
where a=1

[打一壶酱油]

select top  1 Products.PD_ID,PD_name,PD_marketprice,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 order by ProductPicture.PT_ID

[saxok]

有很多商品，不是只有一个数据

[by_封爱]

select
ROW_NUMBER() OVER(order by PD_ID )  as a
Products.PD_ID,
PD_name,
PD_marketprice,
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

为什么不试试我的呢? 我才给你思想了啊?

[saxok]

[Quote=引用 5 楼 diaodiaop 的回复:]
SQL code

select
ROW_NUMBER() OVER(order by PD_ID ) as a
Products.PD_ID,
PD_name,
PD_marketprice,
PD_saleprice,
PT_bigurl from Products,ProductPicture,Pictures
where Products.PD_ID = Product……
[/Quote] 我用的2000 数据库

[好奇都是要学的]

分组后 top1 就是所有商品第一个图片了