Cross server selects?

[Matt Eaton]

Hi all.  Just a quick syntax question.  Is there a way to select rows 
from a different server & database into the one currently in use?  In 
other words, if I had two servers, is there something equivalent to 
saying (while using the client on server1):

SELECT * FROM server2.databasename.tablename WHERE id < 5
I couldn't find anything the manual on this.  Thanks!
-Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]