RE: Data from two tables in one query

2003-10-14 Thread Jeff McKeon
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

RE: Data from two tables in one query

2003-10-14 Thread Jeff McKeon
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

RE: Data from two tables in one query

2003-10-14 Thread Paul DuBois
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

RE: Data from two tables in one query

2003-10-14 Thread Jeff McKeon
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

Re: Data from two tables in one query

2003-10-14 Thread Nitin
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

RE: Data from two tables in one query

2003-10-14 Thread Paul DuBois
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

RE: Data from two tables in one query

2003-10-14 Thread Jeff McKeon
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

Re: Data from two tables in one query

2003-10-14 Thread Paul DuBois
--- Original Message - From: "Jeff McKeon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 14, 2003 4:01 PM Subject: Data from two tables in one query We're currently running mysql ver 3.23 with plans to upgrade to 4.x soon but we're not ready y

Re: Data from two tables in one query

2003-10-14 Thread Rory McKinley
, 2003 4:01 PM Subject: Data from two tables in one query We're currently running mysql ver 3.23 with plans to upgrade to 4.x soon but we're not ready yet. I have two tables that are identical, table1 and table1_old. Table1_old contains all data writen to table1 prior to july of 2003.

Data from two tables in one query

2003-10-14 Thread Jeff McKeon
We're currently running mysql ver 3.23 with plans to upgrade to 4.x soon but we're not ready yet. I have two tables that are identical, table1 and table1_old. Table1_old contains all data writen to table1 prior to july of 2003. I need to do a single query that pulls the same fields from both tab