Page 110 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

4 Show the records of both the tables :
SELECT * from employee;

SELECT * from department;

TASK 3 :Using Joins:
Inner Join - Retrieve rows where there is a match in both tables.

SELECT * FROM employee
INNER JOIN department ON employee.department id = department.department id;

2 Left Join - Retrieve all rows from the left table and the matching rows from the right table.
SELECT * FROM employee
LEFT JOIN department ON employee.department id = department.department id;

95
CITS : IT & ITES - Computer Software Application - Exercise 29 CITS : IT & ITES - Computer Software Application - Exercise 29