have you tried to use a subquery likeselect p.productid as '产品ID',
p.productname as '品名',
(select top 1 productpictureid from productpicture where productid = p.productid) as '图片'
from product p
p.productname as '品名',
(select top 1 productpictureid from productpicture where productid = p.productid) as '图片'
from product p
我试试看尼的方法。。
p.productname as '品名',
min(pp.ProductPictureImage) as 'image'
from product p
left outer join productpicture pp on p.productid = pp.productid
group by p.productid,p.productname
(select top 1 ProductPictureId,ProductPicture
from ProductPicture where ProductID=a.ProductID)
from Product a
FROM
(select p.productid,
p.productname ,
(select top 1 productpictureid from productpicture where productid = p.productid) as 'productpictureid',
from product p
) tLEFT OUTER JOIN productpicture t2
ON t1.productpictureid = t2.productpictureid
FROM [select p.productid,
p.productname ,
(select top 1 productpictureid from productpicture where productid = p.productid) as productpictureid from product p]. AS t LEFT JOIN productpicture AS t2 ON t.productpictureid = t2.productpictureid;saucer:
他们说老大是说你吗?看来真是老大崇敬之情如滔滔江水源源不绝
我还有另一个贴子在oracle版(下面的链接),请去那里接受我的致敬
http://expert.csdn.net/Expert/topic/2864/2864020.xml?temp=.6552698