<P> Note: In the Employee table above, the employee "Williams" has not been assigned to any department yet . Also, note that no employees are assigned to the "Marketing" department . </P> <P> This is the SQL statement to create the aforementioned tables . </P> <P> CROSS JOIN returns the Cartesian product of rows from tables in the join . In other words, it will produce rows which combine each row from the first table with each row from the second table . </P> <P> Example of an explicit cross join: </P>

Which type of join is used in following sql