17,086
社区成员
发帖
与我相关
我的任务
分享
-- 确实很难:
CREATE TABLE C
AS
SELECT A.A,
A.B,
A.C,
B.E,
B.F
WHERE A.B = B.B
AND ROWNUM < 1;
[Quote=引用楼主 zhifeiji007 的帖子:]
/--只创建tableC表结构:
create table tableC as (select ta.a,ta.b,ta.c,tb.e,tb.f from tableA ta ,tableB tb where 1=0);
/--创建tableC表结构及内容:
create table tableC as (select ta.a,ta.b,ta.c,tb.e,tb.f from tableA ta ,tableB tb where 1=1 and ta.b=tb.b);
create table test as select A.a,A.b,A.c,B.e,B.f from A,B