110,571
社区成员
发帖
与我相关
我的任务
分享
SELECT a.* ,
b.时间
FROM ( SELECT * ,
ROW_NUMBER() OVER ( ORDER BY 排序依据字段 DESC ) AS rowNum
FROM 无时间的表
) a
LEFT JOIN ( SELECT * ,
ROW_NUMBER() OVER ( ORDER BY 排序依据字段 DESC ) AS rowNum
FROM 有时间的表
) b ON a.rownum = b.rownum
[/quote]
SELECT a.* ,
b.时间
FROM ( SELECT * ,
ROW_NUMBER() OVER ( ORDER BY 排序依据字段 DESC ) AS rowNum
FROM 无时间的表
) a
LEFT JOIN ( SELECT * ,
ROW_NUMBER() OVER ( ORDER BY 排序依据字段 DESC ) AS rowNum
FROM 有时间的表
) b ON a.rownum = b.rownum