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]>:
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,
t; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>;
Sent: Tuesday, June 19, 2007 12:58 PM
Subject: RE: selecting everyting from 2 non-identical tables.
[snip]
I have two non-identical tables. They are pretty similar except a few
fields. I want to select everything from both for exampl
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
[snip]
I have two non-identical tables. They are pretty similar except a few
fields. I want to select everything from both for example
table1
id
name
age
table2
id
name
height
I want
id
name
height
age
even if it returns null values. select * from table1, table2 seems to
give repeat rows
