Re: [Squirrel-sql-users] joining tables across multiple databases
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Stan D. <sdr...@rn...> - 2012-03-08 23:06:12
|
Sorry for not specifying! It's MySQL databases. Stan On 12-03-08 04:38 PM, CptBlaubaer wrote: Hi Stan, what kind of databases do you use? With Oracle you could use database links, from SQuirreL's point of view you would then query one database. I don't know about another alternative for your ideas. Perhaps you can provide some more information? Take care Andreas Am 08.03.2012 18:24 schrieb "Stan Dragnev" <sdr...@rn...>: Hi, Is it possible to run a query that joins tables across multiple databases in Squirrel SQL? E.g.: select * from db1.table1 inner join db2.table2... I created a user with permissions for both and connected to the host but when trying to query I was getting a no default database selected error. Maybe I'm missing something obvious! Thanks. Stan ------------------------------------------------------------------------------ Virtualization & Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |