In my catalogs, there are many tables with the same structure. Every table is very large, several million records and about 1 GB size. It is impossible to merge them into single one. How can I "select" in all of them at the same time but not "select * from table1 where ..." then "select * from table2 where ...", then ... Thanks cb
=================================================================== 新浪免费电子邮箱 (http://mail.sina.com.cn) 新浪分类信息:分类信息 谁处颠峰? 您投票 我送奖! (http://classad.sina.com.cn/) 新浪闪烁短信闪亮登场 传情无限 (http://sms.sina.com.cn/cgi-bin/sms/smspic.cgi?spec=11&type=0) --------------------------------------------------------------------- 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