How to select from union result?

Question

I have a MySQL script like this:

SELECT ... FROM ... WHERE ...
UNION ALL
SELECT ... FROM ... WHERE ...

now how to select again from the union result?

This doesn't work:

SELECT * FROM (
    SELECT ... FROM ... WHERE ...
    UNION ALL
    SELECT ... FROM ... WHERE ...
);

Answer 1

You need to put an alias for the inner query:

SELECT * FROM (
    SELECT ... FROM ... WHERE ...
    UNION ALL
    SELECT ... FROM ... WHERE ...
) as something;

Answer 2

I think you are asking for this:

   SELECT * FROM (
      SELECT ... FROM ... WHERE ...
      UNION ALL
      SELECT ... FROM ... WHERE ...
    )
    WHERE ...