Result of full outer join

create table a(eid varchar(2),ename varchar(20))

create table b(eid varchar(2),ename varchar(20))

insert into a values('a','xd')

insert into a values('b','yd')

insert into a values('3','c')

insert into b values('c','ee')

insert into b values('d','dd')

insert into b values('3','c')

select * from a

select * from b

select a.*,b.* from a  full outer join b on a.eid=b.eid

---------------------------------

/*a.eid  a.ename b.eid  b.ename

-------------------------------

a                              xd                           NULL     NULL

b                             yd                           NULL     NULL

3                              c                              3              c

NULL                   NULL                       c              ee

NULL                     NULL                     d             dd */

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------