create table a (adate date,value int);
create table b (bdate date,value int);insert into a values(to_date('2011-02-12','YYYY-MM-DD'),5);insert into b values(to_date('2011-02-12','YYYY-MM-DD'),3);
insert into b values(to_date('2011-02-13','YYYY-MM-DD'),7);
insert into b values(to_date('2011-02-12','YYYY-MM-DD'),10);SELECT * fROM A left join B
on adate=bdate
union
SELECT * fROM A right join B
on adate=bdate2个表数据量比较大,有什么办法左右都显示出来速度又快。。上面那个速度怕不够~
create table b (bdate date,value int);insert into a values(to_date('2011-02-12','YYYY-MM-DD'),5);insert into b values(to_date('2011-02-12','YYYY-MM-DD'),3);
insert into b values(to_date('2011-02-13','YYYY-MM-DD'),7);
insert into b values(to_date('2011-02-12','YYYY-MM-DD'),10);SELECT * fROM A left join B
on adate=bdate
union
SELECT * fROM A right join B
on adate=bdate2个表数据量比较大,有什么办法左右都显示出来速度又快。。上面那个速度怕不够~
select * from a full join b on adate=bdate
SELECT * fROM A full outer join B
on adate=bdate