[thelist] selecting tables from two databases

[Scott Dexter]

in MS SQL Server, you can address a table in another database like so:

Select * from dbSales..tbSalesdata

that's two .'s because the userid 'dbo' is assumed. So the syntax is
database.userid.objectname (yes, you can reference stored procs and
whatnot this way as well)

dunno is this is SQL compliant or MS SQL Server specific though...

sgd

> -----Original Message-----
> From: David Kutcher [mailto:david_kutcher at hotmail.com]

> whole ton of stuff, it would be advantageous if I could
> create a method that, whichout too highly taxing the system
> resources, would allow for a mysql query from two local databases.
>