Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select whole "Objects"
jlaffer wrote:
>>CREATE VIEW COMPANY_OBJECTS AS
>>SELECT c.ID COMPANY_ID
>> ,c.NAME COMPANY_NAME
>> ,e.NAME EMPLOYEE_NAME
>> FROM COMPANY c
>> ,EMPLOYEE e
>> WHERE c.COMPANY_ID = e.COMPANY_ID (+)
>>
>>???
>>
>>Or did I misunderstand ?
>>
>>
>
>Well yes.. sorry for my obviously bad description.
>
>If i do the following..:
>
>SELECT * FROM COMPANY_OBJECTS
>WHERE EMPLOYEE_NAME = 'JOHN DOE'
> AND EMPLOYEE_NAME = 'JANE DOE'
>
>.. I, of course, get no rows in my result set.
>What I would need are all lines of all Companies with John and Jane Doe
>on their employee-list.
>
>Thanks for the quick answer,
> Jerry Laffer
>
>
>
SELECT * FROM COMPANY_OBJECTS
WHERE EMPLOYEE_NAME = 'JOHN DOE'
OR EMPLOYEE_NAME = 'JANE DOE'
Received on Wed Feb 15 2006 - 19:22:45 CST