If you use merge you might not be able to tell which records came from which table. If that dosn't matter obviously its not a problem.
----- Original Message ----- From: "Tony Thomas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 16, 2003 2:48 PM Subject: Re: select data from two tables without join : I'm using 3.23.56, so UNION is out. MERGE looks like it might do the : trick. The tables are duplicate other than the field names. The : structure is identical. : : On Tuesday, September 16, 2003, at 08:32 AM, Haydies wrote: : : > 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]