# re: sql----join 2007-08-13 16:49 8383

只要有博客就可以在8383.com免费申请.CN域名，输入域名就能直接进入博客，我刚申请了一个，快输入8383hosting.cn到我的博客看我是如何耍酷吧！  回复  更多评论   

# re: sql----join 2009-06-17 10:45 y

create table dali.test1(a int,b int);
create table dali.test2(a int,b int);

insert into dali.test1 values(1,456);
insert into dali.test1 values(2,427);
insert into dali.test2 values(1,45456);
insert into dali.test2 values(3,45656);

---内连接
select * from dali.test1 a, dali.test2 b where a.a=b.a;

---左连接
select * from dali.test1 a, dali.test2 b where a.a=b.a(+);

---右连接
select * from dali.test1 a, dali.test2 b where a.a(+)=b.a;

---完全连接
select * from dali.test1 a, dali.test2 b where a.a=b.a(+)
union
select * from dali.test1 a, dali.test2 b where a.a(+)=b.a;

---迪卡尔
select * from dali.test1, dali.test2;
'==================================================================
9i和sqlserver一样 left join,right join,full join
  回复  更多评论   

# re: sql----join 2009-06-17 10:45 y

create table dali.test1(a int,b int);
create table dali.test2(a int,b int);

insert into dali.test1 values(1,456);
insert into dali.test1 values(2,427);
insert into dali.test2 values(1,45456);
insert into dali.test2 values(3,45656);

---内连接
select * from dali.test1 a, dali.test2 b where a.a=b.a;

---左连接
select * from dali.test1 a, dali.test2 b where a.a=b.a(+);

---右连接
select * from dali.test1 a, dali.test2 b where a.a(+)=b.a;

---完全连接
select * from dali.test1 a, dali.test2 b where a.a=b.a(+)
union
select * from dali.test1 a, dali.test2 b where a.a(+)=b.a;

---迪卡尔
select * from dali.test1, dali.test2;
'==================================================================
9i和sqlserver一样 left join,right join,full join
  回复  更多评论   

# re: sql----join 2009-06-17 10:45 y

create table dali.test1(a int,b int);
create table dali.test2(a int,b int);

insert into dali.test1 values(1,456);
insert into dali.test1 values(2,427);
insert into dali.test2 values(1,45456);
insert into dali.test2 values(3,45656);

---内连接
select * from dali.test1 a, dali.test2 b where a.a=b.a;

---左连接
select * from dali.test1 a, dali.test2 b where a.a=b.a(+);

---右连接
select * from dali.test1 a, dali.test2 b where a.a(+)=b.a;

---完全连接
select * from dali.test1 a, dali.test2 b where a.a=b.a(+)
union
select * from dali.test1 a, dali.test2 b where a.a(+)=b.a;

---迪卡尔
select * from dali.test1, dali.test2;
'==================================================================
9i和sqlserver一样 left join,right join,full join
  回复  更多评论