Hi, Consider the following schema:
Database.Users: id username Database.Log: id userid1 userid2 entry If I'm SELECT'ing on the Log table and I want to pull usernames out of Users table for both users (which will most likely be unique) is there a specific JOIN for this? Forgive me if I've missed something in the manual pages; I've always had to do two SELECTs and thus have been looking for a quick[er] solution to this for some time now. Thank you in advance! Ron Jamison (moderators: although I've looked at the manual page plenty of times before, http://www.mysql.com/doc/manual.php?search_query=join today produced the following: "Search results Did you mean jan? The search for 'join' produced no results " -- kind of ironic) --------------------------------------------------------------------- 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
