imgzoom表: zoomid(主键), zoomtittle
imginfo表:imgid(主键),imgtittle,imgdesp,imgsmall,zoomid(外键)
在存储过程中实现:
查询:zoomtittle,imgsmall,zoomid 这三个字段(列)
前提:imginfo表中有相同zoomid的时候,只取第一条记录
SELECT A.zoomtittle,B.imgsmall,B.zoomid
FROM imgzoom A CROSS APPLY(SELECT TOP(1)* FROM imginfo B WHERE A.zoomid=B.zoomid order by imgid) B
转载于:https://blog.51cto.com/cnming/767522