Re: selecting everyting from 2 non-identical tables.

[Olexandr Melnyk]

select id, name, age, null as height
  from table1
union
select id, name, null as age, height
  from table2

2007/6/19, ross@stripped <ross@stripped>:
>
> select * from table1, table2 seems to give repeat rows for some reason.


It is a Cartesian product.

-- 
Sincerely yours,
Olexandr Melnyk
http://omelnyk.net/