> I was wondering if and how I could query multiple
> datasources, essentially a simple join on two different
> datasources? I have tables in Oracle and MySQL databases and
> I want to query info from both for a return set.
The easiest way to do this is to use CF's query-of-query functionality,
Thanks,
I was afraid that I was going to have to do a QofQ. I guess I'll
start work on that solution.
Thanks again,
- Charles
On May 23, 2006, at 10:47 AM, Ken Ferguson wrote:
> But, Charles wants to query multiple DATASOURCES, not just multiple
> databases. I think the best way for you to g
It is just a matter of setting up a dblink in Oracle or if it is just
schemas in the same database then it can be as simple as just user
permissions. I seem to recall reading once a way to select data out of
another type of database from within MySQL but I might be remembering
something completely
But, Charles wants to query multiple DATASOURCES, not just multiple
databases. I think the best way for you to get this done Charles is with
a QofQ, as Charlie G. suggested. You'll need to make each of your
queries and then use a query to join the recordsets.
--Ferg
Andy Matthews wrote:
> You
You can query multiple databases as long as you have permissions on both. In
mySQL you prepend the table name with the database name like so:
SELECT d1_t1.listing_id, d1_t1.listing_mlsnumber,d1_t1.listing_type,
d2_t4.pLisPric
FROM databasename_01.table_01 d1_t1
INNER JOIN databasename_02.table_04
You can query multiple databases as long as you have permissions on both. In
mySQL you prepend the table name with the database name like so:
SELECT d1_t1.listing_id, d1_t1.listing_mlsnumber,d1_t1.listing_type,
d2_t4.pLisPric
FROM databasename_01.table_01 d1_t1
INNER JOIN databasename_02.table_04
probably not the sort of solution you're looking for, but i think
you're going to have to use a Query of Queries to accomplish that.
On 5/23/06, Charles E. Heizer <[EMAIL PROTECTED]> wrote:
> Hello,
> I was wondering if and how I could query multiple datasources,
> essentially a simple join on tw
7 matches
Mail list logo