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 variou

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

Re: Cross database queries

2008-04-02 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

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? No. >