李战：
两个行集有主键吗？并且是按主键排序的吗？如果是，就可以
[阅读: 282] 2007-09-07 07:00:13
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
李战(leadzen)
| -ICP -IDC -ISP |