These is earlier known as cartision join.if at all two or more tables are combine to gether without any condition we call it as a cross join.In this case each row of the first table will join with each row of the second table so in the first table has m rows and the second table has n rows.The output will be m*n rows

Example :

Select * from Employee E cross join Department D

7) What is outer joins ? Give an Example ?

This is an extenstion to the existing inner joins .where in case of inner joins we will be getting only the matching records basing on the condtion between the tables where as in case of outer join along with the matching records we can aslo retrived the unmathced data from the tables outer joins are of three types.

a) Left outer join

b) Right outer join

c) Full outer join

8) What is Left outer join ? Give an Example ?

In this case we will be getting the matching records from both the two tables as well as the unmatched records from left hand side table.