Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 1D950476064
	for <pgsql-sql@postgresql.org>; Tue, 22 Oct 2002 18:42:09 -0400 (EDT)
Received: from news.hub.org (news.hub.org [64.49.215.80])
	by postgresql.org (Postfix) with ESMTP id B1AAA475F81
	for <pgsql-sql@postgresql.org>; Tue, 22 Oct 2002 18:42:08 -0400 (EDT)
Received: by news.hub.org (Postfix, from userid 8)
	id 4D98E381634; Tue, 22 Oct 2002 18:42:08 -0400 (EDT)
From: webmaster@alligatorsql.de (www.alligatorsql.com)
X-Newsgroups: comp.databases.postgresql.sql
Subject: Joining tables from different relational databases with AlligatorDBC
Date: 22 Oct 2002 15:24:45 -0700
Organization: http://groups.google.com/
Lines: 23
Message-ID: <9707c3ac.0210221424.456e0b72@posting.google.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: groups-abuse@google.com
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/289
X-Sequence-Number: 10006

Hello everybody,

with AlligatorDBC (database connectivity) you are able to join table from
different relational databases f.e.
a table in MySQL mytab and a table in Oracle oratab

This works for Oracle8i, MySQL, Interbase, Birdstep RDM, PostgreSQL and MSSQL.

Select * from oratab, mytab where oratab.id = mytab.id

Export and Import from f.e. MySQL to Oracle

Create table oratab as Select * from mytab.

If you need information just send us a e-mail to info@alligatorsql.com
We will send you an article about the AlligatorDBC/SQL and the techniques.

Hope that helps ?

Best regards
Manfred Peter
(Alligator Company GmbH i.Gr.)
http://www.alligatorsql.com