Below query is a which type of join?

Select * From employee_master,project_master;

Above query is a Cross join,it is applied on more than one but different tables.It produces the Cartesian product.

So, Cross join, as the name implies,it produces rows which combine each row from the 1st table with each row from the 2nd table. As i also said that,cross join is applied on more than 1 but different table. and in the above query employee_master and project_master are the 2 different tables.
We can also write such query as:
Select * From employee_master cross join project_master;

Suppose,employee_master is having 5 rows and project_master is having 5 rows,then cross join will produce 25 rows meaning that 1st table multiplied by the number of rows in the 2nd table.