On Wed, 5 Mar 2003, Peter Choe wrote:
> if i have database 'A' with a table called 'a' and another database 'B'
> with a table called 'b', is there a way to do a select using both databases
> and their tables?
>
> select * from A.a, B.b;
>
You may wanna have a look at dblink under contrib.
_/_/ _/_/ _/_/ Tariq Muhammad
_/ _/ _/ _/ _/ _/ tariq(at)libertyrms(dot)info
_/ _/ _/_/_/ _/_/_/ v:416-646-3304 x 111
_/ _/ _/ _/ _/ _/ c:416-455-0272
_/_/_/ _/_/_/ _/ _/ p:416-381-1457
_________________________________________________
Liberty Registry Management Services Co.