>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
Actually, what he needs is AND. OR would be UNION.
UNION is in the works for MySQL 4, but AFAIK INTERSECT is not.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
MySQL list magic words: sql query database
---------------------------------------------------------------------
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