@sandy143
4 table joining

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);