JOIN NOW

Informatics Practices

How can we retrieve all records of emp that are not present in emp1?

SQL Queries

2 Likes

Answer

SELECT * FROM emp 
LEFT JOIN
SELECT * FROM emp1;

Answered By

2 Likes

Related Questions