Re: Select whole "Objects"

> 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 Received on Tue Feb 14 2006 - 09:01:16 CST