Re: Cross database queries

2008-04-06 Thread Baron Schwartz
Hi, On Wed, Apr 2, 2008 at 4:34 PM, Ben Roberts [EMAIL PROTECTED] wrote: Hello, Does anybody have any info on cross-database joins? i.e. doing a join across various tables that are located inside different databases (albeit on the same database server). I'm interesested in any

Re: Cross database queries

2008-04-06 Thread Moon's Father
Learnt more from here. On Mon, Apr 7, 2008 at 9:22 AM, Baron Schwartz [EMAIL PROTECTED] wrote: Hi, On Wed, Apr 2, 2008 at 4:34 PM, Ben Roberts [EMAIL PROTECTED] wrote: Hello, Does anybody have any info on cross-database joins? i.e. doing a join across various tables that are

Re: Cross database queries

2008-04-03 Thread Krishna Chandra Prajapati
On Thu, Apr 3, 2008 at 2:04 AM, Ben Roberts [EMAIL PROTECTED] wrote: Hello, Does anybody have any info on cross-database joins? i.e. doing a join across various tables that are located inside different databases (albeit on the same database server). Yes, Implemented and working fine

Cross database queries

2008-04-02 Thread Ben Roberts
Hello, Does anybody have any info on cross-database joins? i.e. doing a join across various tables that are located inside different databases (albeit on the same database server). I'm interesested in any potential pitfalls, limitations, and performance issues. There doesn't appear to be

Re: Cross database queries

2008-04-02 Thread Daniel Kasak
On Wed, 2008-04-02 at 21:34 +0100, Ben Roberts wrote: Hello, Does anybody have any info on cross-database joins? i.e. doing a join across various tables that are located inside different databases (albeit on the same database server). I'm interesested in any potential pitfalls,

Re: cross database queries

2003-12-09 Thread Egor Egorov
H. Steuer [EMAIL PROTECTED] wrote: im just wondering if there are any limitations in cross database queries like: SELECT one.* FROM db1.one, db2.two; are there any differences in joining tables from within various databases to joinin tables from within the same database

cross database queries

2003-12-08 Thread H. Steuer
hello guys, im just wondering if there are any limitations in cross database queries like: SELECT one.* FROM db1.one, db2.two; are there any differences in joining tables from within various databases to joinin tables from within the same database? the background of my question is that various

speed of cross-database queries

2003-09-25 Thread Kevin
Hello, I'm doing this some in my application, and was wondering if anyone had any ideas about the efficiency of cross-database queries: Select * from db1.poems left join db2.users on poems.mid = users.mid My runtime variables do show 319 'change db' queries - but I don't know

Re: speed of cross-database queries

2003-09-25 Thread Jeremy Zawodny
On Thu, Sep 25, 2003 at 11:46:49AM -0700, Kevin wrote: Hello, I'm doing this some in my application, and was wondering if anyone had any ideas about the efficiency of cross-database queries: Select * from db1.poems left join db2.users on poems.mid = users.mid They're no slower than