Обсуждение: how to select * from database1 table,database2 table

Поиск
Список
Период
Сортировка

how to select * from database1 table,database2 table

От
"guard"
Дата:
if join database1 database2

how to make

I use VB or DELPHI

thanks




Re: how to select * from database1 table,database2 table

От
Josh Berkus
Дата:
"guard":

> if join database1 database2
> 
> how to make

Folks, this really needs to be on a FAQ somewhere:

PostgreSQL does not support inter-database Joins.  Period.

If you want to join tables from two different databases, I suggest that
you use your front-end code to do so.  I would also suggest that you
review your data architecture and see if it's really necessary for you
to store your data in two seperate databases.

-Josh Berkus

-- 
______AGLIO DATABASE SOLUTIONS___________________________                                       Josh Berkus  Complete
informationtechnology      josh@agliodbs.com   and data management solutions       (415) 565-7293  for law firms, small
businesses      fax  621-2533   and non-profit organizations.       San Francisco