select a.ACOL1, b.BCOL2, b.BCOL3 from TABLE1 a, TABLE2 b;

SQL> with
  2  -- table1 and table2 is what you currently have
  3  table1 as
  4    (select 'A1' col1, 'A2' col2, 'A3' col3 from dual union
  5     select 'B1', 'B2', 'B3' from dual union
  6     select 'C1', 'C2', 'C3' from dual
  7    ),
  8  table2 as
  9    (select 11 col1, 12 col2, 13 col3 from dual union
 10     select 21, 22, 23 from dual union
 11     select 31, 32, 33 from dual
 12    ),
 13  -- first, let's order these rows
 14  t1_ordered as
 15    (select row_number() over (order by col1) rn,
 16            col1, col2, col3
 17     from table1
 18     ),
 19  t2_ordered as
 20    (select row_number() over (order by col1) rn,
 21            col1, col2, col3
 22     from table2
 23     )
 24  -- now join them on RN
 25  select t1.col1, t2.col2, t2.col3
 26  from t1_ordered t1,
 27       t2_ordered t2
 28  where t1.rn = t2.rn
 29  order by t1.rn;

CO       COL2       COL3
-- ---------- ----------
A1         12         13
B1         22         23
C1         32         33

SQL>