Two_tables

create table emp(
id integer primary key,
name varchar(15),
address varchar(20)
);

create table project(
id int primary key,
pid int,
pname varchar(15),
location text NOT NULL
);

insert into emp values(01,'Rohit','Rohtak');
insert into emp values(02,'Mohit','Sonipat');
insert into emp values(03,'Rohan','Rohtak');
insert into emp values(04,'Naveen','Panipat');
insert into emp values(05,'Mahesh','Gurugram');

insert into project values(01,11,'IOT','Chennai');
insert into project values(02,22,'BIG_DATA','Delhi');
insert into project values(04,33,'JAVA_DEVELOPER','Mumbai');
insert into project values(05,44,'ANDROID','Hydrabad');

select * from emp;
select * from project;

select * from emp where id in (select id from project);