Hi, I have 5 tables in mysql, each of same structure. When some search word is given, I am creating 5 threads to search in 5 tables. Now i need to order the search results in the most suitable order. For example, for a search word, the results from table 3 will be more suitable, where as for another word results from table 2 could be better once. In the first case I need to show the table 3 results first, that is the result returned by thread 3 and for the second case, I should show the results from table 2 that is the thread 2. How can i find this. Kindly help. Regards, Get fast and easy Internet access through http://www.netkracker.com --------------------------------------------------------------------- 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