On Tue, June 19, 2007 23:42, Olexandr Melnyk wrote: > 2007/6/19, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: >> >> 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 <[EMAIL PROTECTED]>: >> >> select id, name, age, null as height >> from table1 >> union >> select id, name, null as age, height >> from table2
I believe that was the right answer to the question. ( there might be other answers ;^) -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
