From: Mogens Melander Date: June 20 2007 1:51am Subject: Re: selecting everyting from 2 non-identical tables. List-Archive: http://lists.mysql.com/mysql/207602 Message-Id: <2533.90.184.17.152.1182304267.squirrel@mail.fumlersoft.dk> MIME-Version: 1.0 Content-Type: text/plain;charset=utf-8 Content-Transfer-Encoding: 8bit On Tue, June 19, 2007 23:42, Olexandr Melnyk wrote: > 2007/6/19, 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 : >> >> 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.