we can fetch records from more than 1 table using join.While executing join there should be a common column between both tables.There are diff types of joins: insert into dept ...