Re: Subquery not allowed here

mike wrote:
> 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

No you don't. A foreign key can be null in the table on which the constraint (TableB in your case) is built.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)