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 ...
select first_name,last_name,email,city from customer join address on customer.address_id=address.address_id join city on address.city_id=city.city_id; select first_name,last_name,rental_date,title ...