Unanswered: MySQL get data from another database server within a select statement
I try to get data from an ISAM or ms sql server database into a MYSQL database using a select statement.
I've done this before with sqlserver and ISAM. I made a linked server and used OpenQuery in my select statement to get the data from another server. Is there a way to do that in MySQL? I haven't found anything like linked server in ms sql server nor something like OpenQuery in MySQL to get data from another server.
select statement in ms sql server looks like
from OpenQuery([linkedServerName], 'Select bField from table')
Thanks for any help, also the confirmation that there is no way to do it in MySQL