INTRODUCTION TO JOINS
A join clause is used in relational database system to combine rows from two or more tables based on a common field between them. It is performed by using ‘where’ or ‘on’ clause in which specify the column name of both table and the condition is that data type should be same in both tables which combines the specified rows of tables.
Consider the following two tables Employees and Orders.
- The employee table has attributes ID, Name, Age, Address, Salary,Mgrid
- The Orders table has attributes OrderID, Date, Employee_ID, Amount,losal,hisal
This content is restricted to site members. If you are an existing user, please log in. New users may register below.