Re: Combining Multiple Tables

2008-09-26 Thread Thomas Pundt
On Friday, 26. September 2008, Tim Carty wrote: | I would like to combine multiple tables into a single table. I can create a | UNION between tables with similar columns ­ cols A, B, and C from table_1 | with cols A, B, and C from Table_2. What I can¹t figure out is how to add | additionals column

RE: Combining Multiple Tables

2008-09-26 Thread Weston, Craig (OFT)
and delete the e-mail from your system. -Original Message- From: Tim Carty [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2008 10:41 AM To: mysql@lists.mysql.com Subject: Combining Multiple Tables I would like to combine multiple tables into a single table. I can create a UNI

Combining Multiple Tables

2008-09-26 Thread Tim Carty
I would like to combine multiple tables into a single table. I can create a UNION between tables with similar columns ­ cols A, B, and C from table_1 with cols A, B, and C from Table_2. What I can¹t figure out is how to add additionals columns (D, E, F) from table_2 if the columns don¹t exist in T