Connect To Foreign Tables

[James Card]

The application I'm working on uses MySQL 5.0.41 and we also need to  
retrieve some data from a SQL-Server database in another department.  
SQL-Server has a feature (that I haven't tested) that allows it to make an  
ODBC connection to a foreign database and treat its tables as if they were  
local.

Is there any way to accomplish something similar in MySQL? I'd love to be  
able to create a view that joins data from my local tables with that from  
SQL_Server.

-- 
James Card
209-578-5580