Entity Integrity Constraints defferncebetween oracle and microsoft sql server code example

Example: Entity Integrity Constraints defferncebetween oracle and microsoft sql server

SELECT d.empno, d.deptname, 
empname = (SELECT ename FROM emp
           WHERE enum = d.empno)
FROM dept d
WHERE deptid = 10