Re: Accessing 2 databases in 4gl
On Fri, Jun 25, 1999 at 05:55:53AM +0000, scott@prettyhorses.net wrote:
> Hello -
>
> I need to join data from 2 tables which are located in different
> databases. Is there a way to do this using 4gl? Also, for another
> program, I need to take data from a table in one database and then
> insert it into a table in a second database. Is this a similar
> procedure and can it also be done using 4gl?
Sure.
SELECT *
FROM database1@server1:table1, database2@server2:table2,
database3:table3
WHERE..
Hope this helps,
Octav
--
Octav Chiriac Phone: (373) 2 22 99 67
NetInfo S.R.L. Fax: (373) 2 21 36 59
Chisinau (373) 2 24 00 83
Moldova, Republic of mailto:com@netinfo-moldova.com