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. 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); thanks, patrick bolduan --------------------------------------------------------------------- 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