李战 · 2007-09-07 07:00:13 · 阅读: 352 两个行集有主键吗？并且是按主键排序的吗？如果是，就可以 select * from (select (select sum(1) from A where k <= alsA.k) rowno, * from A alsA) rstA join (select (select sum(1) from B where k <= alsB.k) rowno, * from B alsB) rstB on rstA.rowno = rstB.rowno
| -ICP -IDC -ISP |