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

Re: Data from two tables in one query

2003-10-14 Thread Rory McKinley
Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) - Original Message - From: Jeff McKeon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 4:01 PM Subject: Data from two tables

Re: Data from two tables in one query

2003-10-14 Thread Paul DuBois
- 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 yet. I have two tables that are identical, table1

RE: Data from two tables in one query

2003-10-14 Thread Jeff McKeon
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 one query Two points about

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

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 query Hi Jeff Have you looked at UNIONS

RE: Data from two tables in one query

2003-10-14 Thread Jeff McKeon
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 poster suggests that MERGE tables are not implemented until 4.0, but this is incorrect. MERGE tables are available as of MySQL

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:

RE: Data from two tables in one query

2003-10-14 Thread Jeff McKeon
, October 14, 2003 11:59 AM To: Jeff McKeon; [EMAIL PROTECTED] 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
: 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 'SuperMailbox' Welcome to the MySQL monitor. Commands end with ; or \g. Your