Page 110 - Computer Software Application TP - Volume 1
P. 110
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