Re: Query Two Databases

2007-02-13 Thread Henrique Dallazuanna
tabase server version ? Regards, Neil >From: Nils Jünemann <[EMAIL PROTECTED]> >To: mysql@lists.mysql.com >Subject: Re: Query Two Databases >Date: Thu, 25 Jan 2007 12:01:48 +0100 > >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >Neil Tompkins schrieb: > >

Re: Query Two Databases

2007-02-13 Thread John Meyer
Neil Tompkins wrote: > Following on from the email below, if I run the query > > SELECT * FROM database1.table, database2.table > > I get the data back, but all the data is in the same row. > > How can I seperate the records ? > > Regards > Neil > > Barring an upgrade, it seems your best bet

Re: Query Two Databases

2007-02-13 Thread Neil Tompkins
would appear I can't use UNION in this version ? Do I have any other options, without upgrading the database server version ? Regards, Neil From: Nils Jünemann <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Re: Query Two Databases Date: Thu, 25 Jan 2007 12:01:48 +0100

Re: Query Two Databases

2007-02-13 Thread Neil Tompkins
At the moment we are using mysql 3.23.58. It would appear I can't use UNION in this version ? Do I have any other options, without upgrading the database server version ? Regards, Neil From: Nils Jünemann <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Re: Query Two Dat

Re: Query Two Databases

2007-01-25 Thread Martijn Tonies
> The databases are on the same server, however the login details for each > database are different. Hmm, I guess that the currently connected user needs to have access to both databases, how else would it get the data? Martijn Tonies Database Workbench - development tool for MySQL, and more!

Re: Query Two Databases

2007-01-25 Thread Duncan Hill
On Thursday 25 January 2007 11:08, Neil Tompkins wrote: > The databases are on the same server, however the login details for each > database are different. > A query executes with the credentials of the authentication used to set up the connection. If you want to query two tables simultaneously

Re: Query Two Databases

2007-01-25 Thread Neil Tompkins
The databases are on the same server, however the login details for each database are different. From: "Martijn Tonies" <[EMAIL PROTECTED]> To: Subject: Re: Query Two Databases Date: Thu, 25 Jan 2007 11:56:37 +0100 > Not sure if this is possible or not. But I'

Re: Query Two Databases

2007-01-25 Thread Nils Jünemann
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Neil Tompkins schrieb: > Not sure if this is possible or not. But I've two identical tables in > two different databases. Is it possible to retrieve data from the > different tables in one query ? (SELECT * FROM db1.table) UNION (SELECT * FROM db2.t

Re: Query Two Databases

2007-01-25 Thread Martijn Tonies
> Not sure if this is possible or not. But I've two identical tables in two > different databases. Is it possible to retrieve data from the different > tables in one query ? Yes, by using this notation: select * from mydatabase.mytable Martijn Tonies Database Workbench - development tool fo

Query Two Databases

2007-01-25 Thread Neil Tompkins
Not sure if this is possible or not. But I've two identical tables in two different databases. Is it possible to retrieve data from the different tables in one query ? Thanks Neil _ MSN Hotmail is evolving – check out the new Wi

Re: Query two databases

2006-08-08 Thread brent
Mazur Worden, Kathy wrote: which column(s) isn't found? Would it happen to be any of the columns you're using a function on? I ask because aliasing those might help. I can confirm that passing the full db name will work with ASP through a recordset. I've set them up like this: Set objConn

RE: Query two databases

2006-08-08 Thread Mazur Worden, Kathy
To: Mazur Worden, Kathy Cc: mysql@lists.mysql.com Subject: Re: Query two databases Mazur Worden, Kathy wrote: I've had success using the fully qualified db, table and column name in a single query like yours below.

Re: Query two databases

2006-08-08 Thread brent
Mazur Worden, Kathy wrote: I've had success using the fully qualified db, table and column name in a single query like yours below. Have you tried sending strSQLCombo through either strConnProd or strConnSales already? K. Mazur Worden Kathy, Just tried referencing one and got the "Item cann

RE: Query two databases

2006-08-08 Thread Mazur Worden, Kathy
; Sent: Monday, August 07, 2006 2:18 AM > To: mysql@lists.mysql.com > Subject: Query two databases > > Hi. I'm running MySQL on a Windows 2003 server and connecting > using classic ASP. > > I'm trying to connect and query two databases using a statement like: > &g

Query two databases

2006-08-07 Thread brent
Hi. I'm running MySQL on a Windows 2003 server and connecting using classic ASP. I'm trying to connect and query two databases using a statement like: strSQLCombo = "select sfproducts.products.sku as psku, sfproducts.products.sortName, sum(mcomorderentry.order