两个表的字段之间有没有关联关系? 如果没有直接就SELECT A.* , B. * FROM A,B
楼主没其他要求的话,只是显示两个表的所有列,就可以用下面的代码: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
SQL> with A as( 2 select 1 SFC,2 usn,3 mo from dual), 3 B as( 4 select 4 SF,5 rlc,6 hl from dual) 5 select A.*,B.* from A,B;
SFC USN MO SF RLC HL ---------- ---------- ---------- ---------- ---------- ---------- 1 2 3 4 5 6
就这样就行啊
两个表的字段之间有没有关联关系?
如果没有直接就SELECT A.* , B. *
FROM A,B
(
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
2 select 1 SFC,2 usn,3 mo from dual),
3 B as(
4 select 4 SF,5 rlc,6 hl from dual)
5 select A.*,B.* from A,B;
SFC USN MO SF RLC HL
---------- ---------- ---------- ---------- ---------- ----------
1 2 3 4 5 6
SQL>