Hi.

On Wed, Nov 28, 2001 at 02:26:45PM +0900, [EMAIL PROTECTED] wrote:
> i want to do this:
> 
> SELECT matrix.matrixId FROM matrix, language WHERE (matrix.fromLanguageId =
> language.languageId AND language.isoLanguageId = 25) AND
> (matrix.toLanguageId = language.languageId AND language.isoLanguageId = 27);
> 
> but the grouping doesn't seem to be working. it this a MySQL limitation or
> (more likely) the manifestation of my limited SQL knowledge? what have i got
> wrong?
> also, if there's a better way to do what i'm trying to do here, please let
> me know.

Well, I am not sure what you want to archieve, but grouping "AND"
makes no difference, because (a AND b) AND c = a AND (b AND c).

> these work, but aren't what i want:
> 
> SELECT matrix.matrixId FROM matrix, language WHERE (matrix.fromLanguageId =
> language.languageId AND language.isoLanguageId = 25) AND
> (matrix.toLanguageId = 27);
> 
> SELECT matrix.matrixId FROM matrix, language WHERE (matrix.fromLanguageId =
> 25) AND (matrix.toLanguageId = language.languageId AND
> language.isoLanguageId = 27);

Sorry, I cannot come up with a solution, because I am still not sure,
what you are trying to do. Could you post a little example which will
illustrate what you are getting with the above query and what you are
expecting.

Bye,

        Benjamin.

-- 
[EMAIL PROTECTED]

---------------------------------------------------------------------
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

Reply via email to