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