I have two tables which have overlapping but nonidentical schema. I want to
creating a new table that unions them, leaving nulls in any given row where a
column name doesn't occur in the other table:
SCHEMA 1: { a, b, c, Y }
row: { 1, 2, 3, 4 }
SCHEMA 2: { a, b, c, Z }
row: { 5, 6, 7, 8 }
NEW SCHEMA: { a, b, c, Y, Z }
new row: { a:1, b:2, c:3, Y:4, Z:null }
new row: { a:5, b:6, c:7, Y:null, Z:8 }
I don't think either "full outer join" or "union all" works. I'm not sure how
to do this. Any ideas?
Thanks.
________________________________________________________________________________
Keith Wiley [email protected] keithwiley.com music.keithwiley.com
"You can scratch an itch, but you can't itch a scratch. Furthermore, an itch can
itch but a scratch can't scratch. Finally, a scratch can itch, but an itch can't
scratch. All together this implies: He scratched the itch from the scratch that
itched but would never itch the scratch from the itch that scratched."
-- Keith Wiley
________________________________________________________________________________
