CREATE VIEW question...

Hello there...
I have two databases, called db1 an db2. Database db1 contains a table
called memberlist.
Now I will create a view, called members, in database db2 (containig data
from table memberlist) with the following query:
CREATE VIEW members AS SELECT * FROM db1.memberlist;
->>> this error is displayed: ERROR; parser: error at or near "."
How can I create a view in one database with data from a second/different
database?
Jan Konzack


-----------------------------------------------------------------------
Riester-Rente - Kassieren Sie das Geld vom Staat:
Zum Förderungsrechner! http://www.arcor.de/home/redir.php/riesterrente
-----------------------------------------------------------------------