Mysql IN Subquery with additional value

Question

I'm trying to select rows using IN but I want to add inside IN statement another value.

Example

SELECT title FROM film WHERE film_id IN (SELECT film_id FROM film_actor)

Ok... Get result..no problem..

SELECT title FROM film WHERE film_id IN ((SELECT film_id FROM film_actor), 130)

How can add another value (130) like the query above?

Tks. Adriano

Answer 1

Try to use union allas below

SELECT title FROM film WHERE film_id IN (SELECT film_id FROM film_actor
                                         union all
                                         SELECT 130)