o 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 table
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:
:
: &g
e 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 tha
t 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
Tony Thomas <[EMAIL PROTECTED]> wrote:
> 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 unnece
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 ot
ion
select train_name as event_name, train_date as event_date
from trainings
where train_date >= curdate()
order by event_date
> -Original Message-
> From: Tony Thomas [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 16, 2003 9:01 AM
> To: [EMAIL PROTECTED]
> Subject:
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 li
