Re: Which column is taken in JOIN with multiple columns and different content ?

Home -> Community -> Usenet -> c.d.o.misc -> Re: Which column is taken in JOIN with multiple columns and different content ?

From: Jim Smith <usenet01_at_ponder-stibbons.com>
Date: Tue, 6 Mar 2007 13:08:58 +0000
Message-ID: <m7MKeViqfW7FFwxn@jimsmith.demon.co.uk>

In message <1173127063.329187.146100_at_j27g2000cwj.googlegroups.com>, Jimmu <JimF_at_cccd.edu> writes
>> Select *
>> FROM tablea a, tableb b
>> Where a.id = b.id
>>
>> tablea:
>>
>> id col1 col2
>>
>> 1 aaa ddd
>> 2 bbb eee
>> 3 ccc fff
>>
>> tableb:
>>
>> id col1 col3
>>
>> 1 zzz uuu
>> 2 xxx vvv
>> 3 yyy www
>>
>> The result table will look like:
>>
>> id col1 col2 col3
>>
>> 1 ??? ddd uuu
>> 2 ??? eee vvv
>> 3 ??? fff www
>>
>> Which values will be for the questions marks ?
>>
>
>Oracle would list the columns as id, col1, col2, col3, id_1, col1_1,
>col2_1, col3_1 and give you values from both tables...
>No?
>
>
>

No.

Did you test what you wrote?

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>

Received on Tue Mar 06 2007 - 07:08:58 CST