Re: [PHP-DB] Query Across DBMS Boundaries (Linked Database Servers?)

2008-03-24 Thread Chris
Dee Ayy wrote: Is there something which can perform a query across different database systems? It would extend the database.table.field notation to maybe dbms.database.table.field and allow queries across MySQL and MSSQL I don't think so. Both mysql and mssql would need to know how to parse

[PHP-DB] Query Across DBMS Boundaries (Linked Database Servers?)

2008-03-20 Thread Dee Ayy
Is there something which can perform a query across different database systems? It would extend the database.table.field notation to maybe dbms.database.table.field and allow queries across MySQL and MSSQL such as: //$sql = SELECT MySQLidentifier.aDatabase.aTable.aField,