I have a table (TABLE1) which contains multiple fields for user-IDs. Some examples are - the user who created it (FLD_U1), who last updated it (FLD_U2), who is the current owner (FLD_U3) and so on.
If I want to make a query and resolve all these IDs to the corresponding user-names, do I need to join the TABLE2 (which contains FLD_UID and FLD_UNAME) as many times as there are fields for user ID in the parent table (TABLE1) or is there some SQL trick which I can resolve all of them with a single join OR is it that ne number of joins using the same table does not affect performance of the query in a significant way. Note that the parent table(TABLE1) may have a million rows and I m picking just one page (about 10-15) rows from it at one go. Thx Vikash --------------------------------------------------------------------- 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
