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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
