-
Is there any error in this query?
SELECT emp.emp_id,
emp.fname, emp.lname, dep.name
FROM employee emp INNER JOIN department dep
ON emp.dept_id = emp.dept_id;
-
- YES
- DEPEND
- NO
- All of above
- None of these
Correct Option: C
There will be no error in the query, as table name “employee” is replaced by ‘e’ and table name “department” is replaced by‘d’.
