This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1B80B.A7FAB120
Content-Type: text/plain
You could do this using a trigger. You might also want to look into using
replication.
regards
David Cameron
nOw.b2b
dcameron@i...
> -----Original Message-----
> From: Denis Gobo [mailto:dgobo@w...]
> Sent: Saturday, 16 February 2002 5:10 AM
> To: sql language
> Subject: [sql_language] Primary Key and Foreign key in different
databases
>
> A question was asked to me and I am not sure if it is possible.
> Can I have a relation between 2 tables that are stored in 2 different
databases
>
> This is what we need to accomplish we will only insert data in 1 table
if it already exists in the other table
>
> I know I can accomplish this by writing a trigger
>
> Thanks in advance
>
> Denis
$subst('Email.Unsub').