Loading

table join

Hardik Patel

reason for join two table??

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Atul Kumar14y ago
Accepted answer
To read the data from other table which is associated with some relationship with first table.
Santhosh Kumar Jayaraman14y ago
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, Salary,Department.

Now you want to get all the four columns, then we ll use join

Select a.EmpId,EmpName,b.salary,b.Department from table1 a
inner join table2 b on b.EmpId=a.EmpId