Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Which column is taken in JOIN with multiple columns and different content ?
On 02 Mar 2007 16:07:59 GMT, merlin_at_gmx.net (Tobias Merler) wrote:
>Assume I join two tables.
>Both of these tables contain a column with name "col1". This column ist not he primary key.
>However this column contains different values which value is taken ?
>
>Lets see the following example:
>
>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 ?
>
>Ok, I know the data model is not perfect and the two tables could be merged.
>But keep in mind that the sample is only a simplified version of a more complex
>SQL statement. So lets concentrate on my question.
>
>Thank you
>
>Toby
>
>
You have output from a SELECT and a 'result table', but you say
nothing about connecting the two. Could you please provide the code
you are intending to use to fill the table from the output?
Jaap. Received on Sun Mar 04 2007 - 03:56:30 CST