|
From: Erwan D. <erw...@gm...> - 2012-04-18 20:27:19
|
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 |
