Database Management System05 marksNumerical: outer join resultsOuter joins
Define Outer Join in SQL. Given following relations, show the results of left and right outer joins. **Employee:** | Eid | Ename | Address | Dno | |---|---|---|---| | 1 | Ram | KTM | 111 | | 2 | Rita | PKR | 222 | | 3 | Hari | KTM | 333 | **Department:** | Dno | Dname | |---|---| | 111 | HRM | | 222
Define Outer Join in SQL. Given following relations, show the results of left and right outer joins.
Employee:
| Eid | Ename | Address | Dno |
|---|---|---|---|
| 1 | Ram | KTM | 111 |
| 2 | Rita | PKR | 222 |
| 3 | Hari | KTM | 333 |
Department:
| Dno | Dname |
|---|---|
| 111 | HRM |
| 222 | Admin |
| 444 | Account |
[5]
Employee (E): Eid Ename Address Dno -------------------------- 1 Ram KTM 111 2 Rita PKR 222 3 Hari KTM 333 Department (D): Dno Dname -------------- 111 HRM 222 Admin 444 Account Join condition: E.Dno = D.Dno --- An Outer Join returns all rows from one or both tables even when there is no matching...