D]
> Subject: RE: Data from two tables in one query
>
>
> At 11:50 -0400 10/14/03, Jeff McKeon wrote:
> >Ok, created the merge table, now I get this error when I log
> into the
> >mysql server
> >
> >[snip]
> >Didn't find any fields in table
Priority tinyint(4), ReadFlagSent int(11), Accounting int(11), QRG
tinytext, Modulation tinytext, RetryCount tinyint(4), LastTry int(11),
RemoteFaxID tinytext,
LLCharge tinytext, LLTime int(11), LLPages int(11), ExternalSerial text,
GPS tinytext, Price Double, User_ID int(11),Pay_ID int(11),
Tarif_I
At 11:50 -0400 10/14/03, Jeff McKeon wrote:
Ok, created the merge table, now I get this error when I log into the
mysql server
[snip]
Didn't find any fields in table 'SuperMailbox'
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3903 to server version: 3.23
aul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 14, 2003 11:19 AM
> To: Jeff McKeon; [EMAIL PROTECTED]
> Subject: RE: Data from two tables in one query
>
>
> At 11:14 -0400 10/14/03, Jeff McKeon wrote:
> >Paul,
> >
> >> - Original post
union isnt available with 3.23 either
Nitin
- Original Message -
From: "Rory McKinley" <[EMAIL PROTECTED]>
To: "Jeff McKeon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 8:01 PM
Subject: Re: Data from two tables in one qu
At 11:14 -0400 10/14/03, Jeff McKeon wrote:
Paul,
- Original poster suggests that MERGE tables are not implemented until
4.0, but this is incorrect. MERGE tables are available as
of MySQL 3.23.25.
Very true, I must have misread. Now my question is, when I create a
merge table, do I have to
m the two tables I'm
merging or can I just grab the ones I want?
Jeff
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 14, 2003 10:54 AM
> To: Rory McKinley; Jeff McKeon; [EMAIL PROTECTED]
> Subject: Re: Data from two tables in
Two points about the messages below:
- With respect to the suggestion to use UNION: Original poster is using
3.23, so UNION cannot be used (it's implemented in MySQL 4.0)
- Original poster suggests that MERGE tables are not implemented until
4.0, but this is incorrect. MERGE tables are availa
Hi Jeff
Have you looked at UNIONS? An example would be something as follows:
SELECT field_1, field_2, field_3
FROM table 1
WHERE blah blah blah
UNION
SELECT field_1, field_2, field_3
FROM table 1_old
WHERE blah blah blah
ORDER BY field_1
This should do the trick...
Rory McKinley
Nebula Solution