Answer:
This query is used when you need to join two tables and get the ouput based on where clause. Suppose you have two tables one for maintaining your Employee details and the other for Departments present in your company.
When you want to know in departments the Employee is present then you can use this query.
Asked In: Many Interviews |
Alert Moderator