Hi,
If you mean joining data from two different database type or server, eg.
from Oracle and MySQL, or from Oracle on server1 and Oracle on server2:
No this is not possible with Squirrel.
However:
In some RDBMS like MS SQL Server, one can define several databases in
the same database instance. In that case, you can use the syntaxe
<dbname>.<schemaname>.<tablename> to build a query that joins data
across databases.
Also, some RDBMS like Oracle or PostgreSQL can define access to remote
databases (db-link in Oracle) or different RDBMS, but this is a RDBMS
feature, not related to SQuirreL.
Erwan
Le 18/04/2012 16:31, David Edwards a écrit :
> Hi Squirrel
> Can one do a query with Squirrel-SQL joining data from different databases in the same query?
>
> Thanks,
> David
> ------------------------------------------------------------------------------
> Better than sec? Nothing is better than sec when it comes to
> monitoring Big Data applications. Try Boundary one-second
> resolution app monitoring today. Free.
> http://p.sf.net/sfu/Boundary-dev2dev
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop
|
