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 variou
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
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
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,
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 mu
"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
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
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
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 -
