> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Marco Lazzeri
> Sent: Saturday, January 24, 2004 7:19 AM
> Cc: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] If table A value IS NULL then table B
>
> > I think this post belon
Il ven, 2004-01-23 alle 19:59, Ezra Epstein ha scritto:
> > I've got a table called 'main' described as follow
> >
> > CREATE TABLE main (
> > id_other_table INT,
> > value CHAR
> > );
> >
> > and a table called 'other' described as follow
> >
> > CREATE TABLE other (
> > id INT PRIMARY KEY,
Yes, id_other_table IS a foreign key to id and usually I've got records
in each table.
Thanks to all of you!
Il ven, 2004-01-23 alle 21:45, [EMAIL PROTECTED] ha scritto:
> As for the outer join, I think that the problem was ambiguous.
>
> Is id_other_table a foreign key to id? Is there at most o
