Re: How create results with an Outer Join using 2 different databases

I was able to use some sample data to create a simple Left Join and got results using 2 different databases. Thank you. I learned something. I need to learn more though. Here's kinda pseudo-code for what I need to end up with: I need the results of my first query to get the data for the

Re: How create results with an Outer Join using 2 different databases

Hi Joy, There may be a work around. If they are both MS SQL Servers for example... If the two datasources point to the same server and just different databases, you can do it inline with your SQL Statement assuming they share the same user credentials. However, I'll assume this is not the

Re: How create results with an Outer Join using 2 different databases

If your RDBMS doesn't support the creation of some sort of database link (which lets you query another database from within the RDBMS), you'll probably have to loop over the results and build up a query result set manually. On 9/5/07, Joy Holman [EMAIL PROTECTED] wrote: ISSUE: I'm working

RE: How create results with an Outer Join using 2 different databases

You probably cannot do an outer join with two different data sources (I'm not sure,,, but seems iffy) You may be able to do a subquery with two data sources. A subquery could work an outer join. If that doesn't work you may be able to query on DB, the loop through the records and run the second