Types of joins and difference between truncate and delete

• Types of joins: inner join, left join, right join, full outer join, self join

• Inner join returns only matching rows from both tables

• Left join re...read more