Re: selecting everyting from 2 non-identical tables.

[Olexandr Melnyk]

2007/6/19, ross@stripped <ross@stripped>:
>
> My frist post was not worded correctly. I cannot join two tables as all
> the
> rows are unique.


What's wrong with my solution?

2007/6/19, Olexandr Melnyk <omelnyk@stripped>:
>
> select id, name, age, null as height
>   from table1
> union
> select id, name, null as age, height
>   from table2


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