SQLize Online / PHPize Online  /  SQLtest Online

with new1 AS (select film_id, c.name from film_category inner join category c on film_category.category_id=c.category_id where c.name like 'Music'), new2 AS (select film_id, c.name from film_category inner join category c on film_category.category_id=c.category_id where c.name like 'Comedy'), new3 AS (select film_id, c.name from film_category inner join category c on film_category.category_id=c.category_id where c.name like 'Travel') -- new4 AS (select* from new1 inner join new2) select * from new1 CROSS join new2 -- select * from film -- select * from category -- select * from film_category -- select film.film_id, film.title, category.name as category -- from film left join category on new.category_id=film_category.category_id -- where category.name like 'Music' -- order by film_id -- right out join category.name as category -- from category -- select film.film_id from film -- where category.name like 'Music'