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
Use null (or custom text) to replace the missing columns
A quick ex:
Select a,b,c,null,d from table1
Union all
Select d,'test valid',e,f,g from table 2
This e-mail, including any attachments, may be confidential, privileged or
otherwis
