On Oct 1, 3:19 pm, j <[EMAIL PROTECTED]> wrote:
> How can I make this query work in sqlplus w/o using a cursor?
>
> A.member varchar(8)
> B.member varchar(8)
> B.membersep varchar(10) first 8 characters are member and the last
> are for seperator.
> B.mbrfee number 7
>
> What I am trying to accomplish is get a list of member from table b
> that do not have a mbrfee.
> For example:
>
> A.Member = 12345678
> B.Member = 12345678 but B-Members are 1234567801,
> 1234567802,1234567803 etc if any of these members has a mbrfee > 0 I
> want to throw that record away and go read the next record.
> I hope this makes sense
I am obviously missing something because I would just do ...
select * from B where nvl(mbrfee,0) = 0
not sure why you even mention A because you arent using it
Rob
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
