Re: Subquery not allowed here

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 30 Aug 2005 00:50:46 +0200
Message-ID: <df03g2$pqn$01$1@news.t-online.com>

mike schrieb:
> Sometime there is not a supplier_id!!
>
> If I default it to 0, then I'll have to put a dummy 0 in tablea.
>
> Mike
>

If i understand you correct, the supplier_id may be NULL regarding the tableb. In that case why do you complain about that ? Defining the foreign key constraint you enforce that all the supplier_id's in tableb should be included in the tablea or be NULL. If i misunderstood your business rules, then, please, describe your problem more precisely.

Best regards

Maxim Received on Mon Aug 29 2005 - 17:50:46 CDT