MySQL CROSS JOIN

Cross JOIN is a simplest form of JOINs which matches each row from one database table to all   rows of another. In other words, it gives us combinations of each row of first table with all records in second table.

Syntax

SELECT select_list

FROM table_1

CROSS JOIN table_2;

Example

SELECT r.rollno, r.name, f.fees, f.status

FROM register r

CROSS JOIN fees f ON r.rollno = f.id;