select id, name, age, null as height from table1 union select id, name, null as age, height from table2
2007/6/19, [EMAIL PROTECTED] <[EMAIL PROTECTED]>:
select * from table1, table2 seems to give repeat rows for some reason.
It is a Cartesian product. -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/