SQL Joins
![Image](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVHoT3Q8UTeJ1XXhU-5a1awiQIpk1NLtbicI4xBAKMcse_DUY1_QtyZddllB8WSu8T8HgchQOE8doVREY3GGwltrYqSeNj5U0B4gs9dHmhbb_MM70VICJoZEuLzPiM8Mqzqu033V3L_msP/s640/capture20160411222936996.png)
/*CREATE TABLE tbl_Employee_Data*/ CREATE TABLE tbl_Employee_Data ( EMPID INT, FIRST_NAME VARCHAR(50), MIDDLE_NAME VARCHAR(50), LAST_NAME VARCHAR(50), NATIONALITY VARCHAR(50) ); INSERT INTO dbo.tbl_Employee_Data (EMPID, FIRST_NAME, MIDDLE_NAME, LAST_NAME,NATIONALITY) VALUES (101, 'SUBAL', 'CHANDRA', 'DAS', 'INDIAN'); INSERT INTO dbo.tbl_Employee_Data (EMPID, FIRST_NAME, MIDDLE_NAME, LAST_NAME,NATIONALITY) VALUES (103, 'RANGA', 'SELAM', 'REDDY', 'INDIAN'); INSERT INTO dbo.tbl_Employee_Data (EMPID, FIRST_NAME, MIDDLE_NAME, LAST_NAME,NATIONALITY) VALUES (104, 'SUBHANI', 'SK', 'MAHABOOB', 'INDIAN'); INSERT INTO dbo.tbl_Employee_Data (EMPID, FIRST_NAME, MIDDLE_NAME, LAST_NAME,NATIONALITY) VALUES (106, 'BHARGHAVI', 'CHANDRA', 'RAVULAPALLI', 'INDIAN'); INSERT INTO dbo.tbl_Employee_Data (EMPID, F