Untitled

create table firsttable(id int,name varchar(10));
insert into firsttable values(01, 'safi') ;
insert into firsttable values(02, 'afraa') ;
insert into firsttable values(03, 'druga') ;
select * from firsttable;
create table secondtable(id int,name varchar(10));
insert into secondtable values(04, 'devi priya') ;
insert into secondtable values(05, 'nivetha') ;
insert into secondtable values(06, 'safi') ;
select * from secondtable;
select name from firsttable union select name from secondtable;
select name from firsttable union all select name from secondtable;
select name from firsttable intersect select name from secondtable;