It seems to me that this is more a function of the database than of Perl. Standard SQL syntax (as far as I know) doesn't define how to join tables between databases. Some databases, Oracle or Access for example, allow you to link tables between one database and another, then you can just use standard SQL join syntax as if they were both in the same database. (Access, and maybe Oracle too, also support non-standard syntax to do the same without linking.) But I don't know if or how mySQL does linking, or if there is any Perl module which offers any additional options.
I'd start by looking at mySQL more closely rather than Perl. Hope this helps a little, even though it doesn't solve your problem. > -----Original Message----- > From: Aaron Shurts [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 05, 2001 4:40 PM > To: [EMAIL PROTECTED] > Subject: RE: PERL and MySQL > > > Two separate tables in two separate databases. I know it's > way over my > head. We have an archive db and a production db. I need > some data from > a merge table out of the archive db and I need some area code info out > if the phonebook table in the production db. > > -_-Aaron > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, December 05, 2001 1:36 PM > To: Aaron Shurts > Subject: RE: PERL and MySQL > > > Two separate DATABASES, or just two separate tables? > > > -----Original Message----- > > From: Aaron Shurts [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, December 05, 2001 4:32 PM > > To: [EMAIL PROTECTED] > > Subject: PERL and MySQL > > > > > > Hey all, > > I am pretty new with both PERL and MySQL and I have been > > asked to write > > a report that will collect from our database how many users > > were dialing > > from a specific area code in a given time. I am totally confused on > > JOINS since the data I need to gather is in 2 separate > > databases. I was > > just wondering if someone could help me out with a 20,000 > feet view of > > things or point me to a good URL that explains PERL and MySQL > > joins and > > what-not. Thanks in advance for the info. > > > > Aaron Shurts > > > > > > > > -- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > This message may contain information which is private, privileged or > confidential and is intended solely for the use of the individual or > entity > named in the message. If you are not the intended recipient of this > message, > please notify the sender thereof and destroy / delete the message. > Neither > the sender nor Sappi Limited (including its subsidiaries and > associated > companies) shall incur any liability resulting directly or indirectly > from > accessing any of the attached files which may contain a virus or the > like. > This message may contain information which is private, privileged or confidential and is intended solely for the use of the individual or entity named in the message. If you are not the intended recipient of this message, please notify the sender thereof and destroy / delete the message. Neither the sender nor Sappi Limited (including its subsidiaries and associated companies) shall incur any liability resulting directly or indirectly from accessing any of the attached files which may contain a virus or the like. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
