Thank you @Sudarsan
But when i use
SELECT * FROM employee CROSS JOIN department where employee.LastName=Jones;
i am getting an error 'Invalid column name 'Jones'.'
I want to apply some conditions on CROSS JOIN..