On 11 Apr 2001, at 11:16, [EMAIL PROTECTED] wrote:
> Good morning,
> Please,
> I use MySql, I would use INTERSECT/UNION functions and they
> don't work, I need help,
>
> My query is :
>
> select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From
> Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where
> (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like
> 'word1%') and C.CategoryCode=E.SubCategoryCode order by
> ME.Emplacement
>
> INTERSECT
>
> select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From
> Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where
> (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like
> 'word2%') and C.CategoryCode=E.SubCategoryCode order by
> ME.Emplacement
>
>
> Thank you.
Is this an late April Fool's prank? Why not use OR with
the (M.Mot like 'wordX%') phrases? AFAIK there is no
INTERSECT verb in MySQL. Is there?
David
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php