Re: Select whole "Objects"

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Tue, 14 Feb 2006 06:48:56 -0800
Message-ID: <MPCdnYWwcp9KcGzeRVn-rA@comcast.com>

jlaffer wrote:

>
> In other words, is there a possibility to make it look like this?:
> SELECT * FROM COMPANY_OBJECTS
> WHERE EMPLOYEE_NAME != 'JOHN DOE'
> AND EMPLOYEE_NAME = 'JANE DOE'
>

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 ? Received on Tue Feb 14 2006 - 08:48:56 CST