Hi Greg, > SELECT f.language as From, t.language as To > FROM language f, language t, language_pairs lp > WHERE f.id = lp.from > AND t.id = lp.to;
I really need to get some sleep I think. So simple, and yet my buggy mind didn't come up with that solution. Thanks, //andreas (sql, query - just to satisfy the filter) --------------------------------------------------------------------- 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
