On Thu, 5 Jun 2003 10:50:45 +0100, Tim Bunce wrote:
[quoting from the root message:]
>> >> SELECT $cols FROM tbl1@"$dsn1" ... JOIN tbl2@"$dsn2" ...
>I think we're very much in the realms of inventing our own syntax here.
>We're just using 'standard sql' as a guide for everyones sanity.
FWIW, MySQL allows the syntax
SELECT * FROM database.table
where "table" is the name of a table in the database with name
"database". I'm not sure how standard that is :)
Both databases, the one you connect to, and the one mentioned here,
must (?) reside on the same MySQL server, though. It's the only way I
expect it to behave sanely, anyway.
--
Bart.
