@sandy143

4 table joining

June 24, 2022 · SQL
create table emp(e_id int(5),e_name varchar(15));
insert into emp values(101,'sandeep');
insert into emp values(102,'bargav');
insert into emp values(103,'shiva');
insert into emp values(104,'naresh');
select * from emp;
create table details(e_id int(5),d_id int(5),salary int(10));
insert into details values(201,1001,1000);
insert into details values(202,1002,2000);
insert into details values(203,1003,3000);