RE: Selecting across servers, JDBC

2002-03-13 Thread Zengfa Gao
buffer > overruns...What more can I say? > > Thanks again, > David > > > -Original Message- > From: Gurhan Ozen <[EMAIL PROTECTED]> > To: David Buerer <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > Date: Wed, 13 Mar 2002 18:29:34 -0500 > Subject

RE: Selecting across servers

2002-03-13 Thread David Buerer
..fast...not bloated..simple...feature rich...no buffer overruns...What more can I say? Thanks again, David -Original Message- From: Gurhan Ozen <[EMAIL PROTECTED]> To: David Buerer <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Date: Wed, 13 Mar 2002 18:29:34 -0500 Subject: RE: Se

RE: Selecting across servers

2002-03-13 Thread Gurhan Ozen
SELECT databasename.tablename.column, databasename.tablename.column FROM databasename.tablename, databasename.tablename; Gurhan -Original Message- From: David Buerer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 6:14 PM To: [EMAIL PROTECTED] Subject: RE: Selecting across

RE: Selecting across servers

2002-03-13 Thread Gregory Junker
SELECT * FROM database1.table1 ... database2.table2 ... WHERE > -Original Message- > From: David Buerer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 6:14 PM > To: [EMAIL PROTECTED] > Subject: RE: Selecting across servers > > > How do

RE: Selecting across servers

2002-03-13 Thread Paul DuBois
qualify references to its tables. > >David Buerer >Senior Designer >PLA Designs, Inc. > > >-Original Message- >From: Ken Menzel [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, March 13, 2002 1:21 PM >To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >Subject: Re

Re: Selecting across servers

2002-03-13 Thread Paul DuBois
At 15:00 -0600 3/13/02, Cal Evans wrote: >Is it possible to issue 1 select that gathers data from databases on 2 >separate servers? No. Every now and then, someone alleges that this can be done. But it always turns out to be someone who hasn't actually tried it. :-) > >=C= >* >* Cal Evans >* Jo

RE: Selecting across servers

2002-03-13 Thread David Buerer
How do you do it from different databases on the same server? David Buerer Senior Designer PLA Designs, Inc. -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 1:21 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Selecting across

Re: Selecting across servers

2002-03-13 Thread Ken Menzel
Nope; two databases on the same server OK, but not different servers. Ken - Original Message - From: "Cal Evans" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 4:00 PM Subject: Selecting across servers > > Is it possible to issue 1 select that gathers data