Select from following answers:- Inner Join
- Cross Join
- Self Join
- All of the above.
- All Above
It will be called as Inner Join.Because we know that,Cross Join does not contain WHERE CLAUSE.
For example:-
Select * from employee_master,project_master; ->Cross Join
Select * from employee_master,project_master where condition ->Inner Join.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator