select A from tableA (结果: A1,A2,A3,A4)
select B from tableB (结果: b1,b2,b3,b4)2个表之间没有任何关系,现在要展示成如下
A B
--- ----
A1 b1
A2 b2
A3 b3
A4 b4高手们这怎么弄,请帮个忙,直接用sql能搞定吗
select B from tableB (结果: b1,b2,b3,b4)2个表之间没有任何关系,现在要展示成如下
A B
--- ----
A1 b1
A2 b2
A3 b3
A4 b4高手们这怎么弄,请帮个忙,直接用sql能搞定吗
(select cola, rownum rna from a) aa,
(select colb, rownum rnb from b) bb
where aa.rna = bb.rnb;