CREATE TABLE A
(
 SFC NUMBER,
 USN NUMBER,
 MO NUMBER
);
CREATE TABLE tab_B
(
 SF NUMBER,
 RLC NUMBER,
 HL NUMBER
);

INSERT INTO A VALUES(1,2,3);
INSERT INTO B VALUES(4,5,6);

SELECT SFC,USN,MO,SF,RLC,HL FROM A,B;

       SFC        USN         MO         SF        RLC         HL               
---------- ---------- ---------- ---------- ---------- ----------               
         1          2          3          4          5          6

------解决方案--------------------

select A.* from a join b on a.id = b.aid