Hi,

I'm running MySQL 5.0 on Linux. I have created three databases on
localhost, all accessible by the same user. The names of the
databases are USER1, USER2, and SUPER_USER. Databases USER1 and USER2
have the following table:

YEARLY_SALES
-------------------------
YEAR INTEGER,
SALES FLOAT UNSIGNED

Is it possible to write a single query to list sales for the year 2007
for both USER1 and USER2?

Thanks, - Dave