If I did a merge, would I still be able to separate them out with PHP? For instance:
while ($row=mysql_fetch_array($result)) { echo $row[meet_date] . "<br />\n" . $row[training_date] . "<br />\n"; }
Or do field names need to be identical too (thus eliminating any chance of keeping the data separate)?
On Tuesday, September 16, 2003, at 09:42 AM, Haydies wrote:
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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]