If the tables are the same, then maybe you could use one table with a field that tells the "application" if its a meeting or training.
Other then that, UNION is very cool. As long as you have the same field definitions in 2 or more queries they can be added togeather. Unfortunatly you can do sub selects in 4.0.1 :-( so the list will always come out with the first table at the top, the second following..... On a non-MySQL point, if you do select using a union but want every thing to be sorted as if it was one table then you can always use an array to store the records and sort that. It works really well with PHP. This is also a solution if you are using MySQL 3.x as that dosn't support UNION. Haydies. ----- Original Message ----- From: "Tony Thomas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 16, 2003 2:01 PM Subject: select data from two tables without join : 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]
