-------------------- ANY OPERATOR SELECT title, category_id FROM film INNER JOIN film_category USING(film_id) WHERE category_id = ANY( SELECT category_id FROM category WHERE NAME = 'Action' OR NAME = 'Drama' ); -------------- IN OPERATOR SELECT title, category_id FROM film INNER JOIN film_category USING(film_id) WHERE category_id IN( SELECT category_id FROM category WHERE NAME = 'Action' OR NAME = 'Drama' );
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter