On Fri, 24 Aug 2001, uncleleo wrote: > I am attemping to create multiple databases with Postgresql ver. 7.0.3 > running on Mandrake 8.0 rpm. The tool that I am using is Pgadmin ver 7.1.0. > > Can someone tell me how I can connect to different databases in a single > select statement? Such as, I have a database named "Customer" and another > named "Products". I wish to Select from table A in the Customer database > and table A in Products database. I know that its possible in SQL Server and > other databases. You currently don't... See archives for lots of discussion of this recently (mostly part of the mysql/pgsql thread I think). ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]