If the tables are *identical* in structure ant are MyISAM, you can create a MERGE table from them.
See http://www.mysql.com/doc/en/MERGE.html Alec --------------------------------------------------------- I have two tables that are similar, but not related. One is for meetings and the other for training. I'd like to run a query to select data from both based on the date so I can display the information on a web page. Is that possible? It seems unnecessary to run a separate query for each. I'd like to do something like this: SELECT * FROM meetings, trainings WHERE (meet_date >= CURDATE()) AND (train_date >= CURDATE()) ORDER BY meet_date DESC, train_date DESC; But this doesn't work. Is something like this possible? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
