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
