Select from following answers:- Self Join
- Cross Join

- Inner Join
- Equi Join
- All Above
Above query is a Cross join,it is applied on more than one but different tables.It produces the Cartesian product.
So, Cross join, as the name implies,it produces rows which combine each row from the 1st table with each row from the 2nd table. As i also said that,cross join is applied on more than 1 but different table. and in the above query employee_master and project_master are the 2 different tables.
We can also write such query as:
Select * From employee_master cross join project_master;
Suppose,employee_master is having 5 rows and project_master is having 5 rows,then cross join will produce 25 rows meaning that 1st table multiplied by the number of rows in the 2nd table.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator