selecting everyting from 2 non-identical tables.

[<ross]

I have two non-identical tables. They are pretty similar except a few fields.  I want to
select everything from both for example

table1

id
name
age


table2

id
name
height


I want

id
name
height
age


even if it returns null values. select * from table1, table2 seems to give repeat rows for
some reason.



Thanks,


R.