Re: Difficult SQL Query
From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1997/09/18
Message-ID: <342182F9.1A8D_at_charlie.cns.iit.edu>#1/1
Date: 1997/09/18
Message-ID: <342182F9.1A8D_at_charlie.cns.iit.edu>#1/1
James Bourne wrote:
>
> All,
>
> I am having a problem getting a query to work:
>
> I have two tables where I want to find the difference
> between the two:
>
> Table1
> Attribute1 Number(8)
>
> Table2
> Attribute1 Number(8)
>
> I want to select all Table1.Attribute1 where
> Table1.Attribute does not exist in Table2
>
> How can I do this?
>
> Secondly, I am setting up a cursor in Pro*C and
> whenever not more records are found I want to return
> a failure value.
>
SELECT ATRRIBUTE1 FROM TABLE1
MINUS
SELECT ATTRIBUTE1 FROM TABLE2;
AMAR
-- ****************************************************************************** AMARENDRA B NETTEM 5039 N E River Road, Apt. 1A Certified Oracle DBA NORRIDGE, IL 60656 Whittman-Hart Inc., 311 South Wacker Drive, Suite 3500 Chicago, IL 60606. Ph.No. (708) 583 9870 (H) (312) 913 6758 (W) E-mail:nettama_at_charlie.cns.iit.edu, anettem_at_whittman-hart.com Homepage: http://www.iit.edu/~nettama **************************************************************************** Opinions are mine and do not necessarily reflect those of Whittman-hart Inc.Received on Thu Sep 18 1997 - 00:00:00 CEST