What is a join and their types?
Join can be defined as an operation that includes the retrieval of data from more than one table at a time. Various Types of Joins: Inner Joins Outer Joins Cross Joins Equi Joins Natural Joins Self Joins