Multi DBI query

From: dumpexec@xxxxxxxxx
Date: 26 Feb 2007 01:17:24 -0800

Hi,
I am currently writing a DBI application with a web based front end.

Would it be possible to join two or more queries from different
database together? For instance ifi had a query as below

Select * from db.user1 where username in (select user from db.user2)

But in this case, db.user2 is hosted on another server, probably on
another database type. Would it bhe possible to use perl DIB to
generate this sort of query?

thanks

.

Prev by Date: DBD::Oracle-1.19 installation error
Next by Date: DBD::Oracle question?
Previous by thread: DBD::Oracle-1.19 installation error
Next by thread: DBD::Oracle question?
Index(es):
- Date
- Thread

Relevant Pages

Re: access 2003
... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
(microsoft.public.access.conversion)
Re: access 2003
... I removed the parameters from the form query source. ... synchronize combo boxes to the detail section or the parameter form query ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would ...
(microsoft.public.access.conversion)
Re: Query In BE database
... that would give the users "live" access to the underlying queries. ... When selected from the drop-down list box, I what the the query that is ... What Is A Remote Query? ... point your local query to a query that was in another Access database. ...
(microsoft.public.access.queries)
Re: merge multiple databases
... You need to create a new Access datafile (mdb) to store all in. ... Open the newly created Access database. ... Click on the Queries icon. ... "Create new query", then select lnkDrive as the table to ...
(microsoft.public.vb.database.dao)
Re: merge multiple databases
... You need to create a new Access datafile (mdb) to store all in. ... Open the newly created Access database. ... Click on the Queries icon. ... "Create new query", then select lnkDrive as the table to ...
(microsoft.public.vb.general.discussion)