Re: [Squirrel-sql-users] joining tables across multiple databases

[CptBlaubaer <cpt...@gm...>]

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
>