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
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
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 s
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
it depends on how you want it
if you want them consecutively, you probably want to UNION two queries together, but
you need to make sure that the column types are identical...
i.e.
select meeting_name as event_name, meet_date as event_date
from meetings
where meet_date >= curdate()
union
se
