Re: Selecting from joined tables (simple question)

willy_gates wrote:

>>SQL> SELECT keyword FROM v$reserved_words
>> 2 WHERE keyword IN ('ID', 'VALUE');
>>
>>KEYWORD
>>------------------------------
>>VALUE
>>ID
>>
>>SQL>
>>
>>Could you, perhaps, come up with worse names for your columns?

> 
> 
> OK point taken but this was only a simplified example of my more complicated
> scenario and OK I should not have chosen those names.
> 
> BUT I have a feeling that the column name ID is autogenerated by Oracle
> Designer when there is no PK specified.

I certainly hope not. But if it is ... change it.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)