table join

Question

reason for join two table??

Atul Kumar · Answer

To read the data from other table which is associated with some relationship with first table.

Santhosh Kumar Jayaraman · Answer

If you want to get records and columns from 2 tables the you have to use join. For eg table1 have EmpId EmpName table2 have EmpId SalaryDepartment. Now you want to get all the four columns then we ll use join Select a.EmpIdEmpNameb.salaryb.Department from table1 a inner join table2 b on b.EmpId=a.EmpId