Every derived table must have its own alias error

user_378622 0
Viewed 42254

I get that error when running the following query:

SELECT MAX( DateTime )
FROM (
(
    SELECT DateTime
    FROM Class_Searches
)
UNION ALL (
    SELECT DateTime
    FROM Book_Searches
)
)
WHERE User_Email = 'bla@blah.com'
AND DateTime > NOW( ) - INTERVAL 30 DAY

I know I need to add Aliases but I'm not sure where

mysql sql
2 Answers
Related