Re: Union EXACT Tables

2004-02-24 Thread Lorderon
Thanks for your help... appreciate it... MERGE table type is what I searched for :-) Thanks -Lorderon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Union EXACT Tables

2004-02-24 Thread Paul DuBois
At 19:18 +0200 2/24/04, Lorderon wrote: "Paul DuBois" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] At 19:04 +0200 2/24/04, Lorderon wrote: >Is there a way to make concat 2 tables together without using UNION ? >The tables are EXACTLY SAME, but they sit on 2 different DBs. >And I

Re: Union EXACT Tables

2004-02-24 Thread vpendleton
Would creating a merge table be a solution for you? >> Original Message << On 2/24/04, 11:04:53 AM, Lorderon <[EMAIL PROTECTED]> wrote regarding Union EXACT Tables: > Hello All, > Is there a way to make concat 2 tables together without using UNION ? > The table

Re: Union EXACT Tables

2004-02-24 Thread Lorderon
"Paul DuBois" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > At 19:04 +0200 2/24/04, Lorderon wrote: > >Is there a way to make concat 2 tables together without using UNION ? > >The tables are EXACTLY SAME, but they sit on 2 different DBs. > >And I want to run the SAME where clause on

Re: Union EXACT Tables

2004-02-24 Thread Paul DuBois
At 19:04 +0200 2/24/04, Lorderon wrote: Hello All, Is there a way to make concat 2 tables together without using UNION ? The tables are EXACTLY SAME, but they sit on 2 different DBs. And I want to run the SAME where clause on both tables... What's the problem with using UNION? -- Paul DuBois, MyS