al Message -
From: "Bart Nessux" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 10, 2004 8:07 PM
Subject: Re: Validation/Linking Table Question
> Thanks Lou, I'll give this a go!
>
>
> >From: "Lou Olsten" <[EMAIL PROTECTED]>
> &
Assuming that your pre 4.1, meaning that you can't use a subquery this
will do it, BUT comp_id must be set to allow NULLS for this to work
otherwise the optimizer will handle it differently
(http://dev.mysql.com/doc/mysql/en/LEFT_JOIN_optimisation.html). It is
legal to create a primary key on
