I was hoping I could get some help with a query. I have a read of a membermaster file (table a) and it uses the key member to read table b (memberdetl). The key is mbrno varchar 8 Memberdetl also has a field called mbrsep which is varchar 10 the first 8 characters are mbrno and the last 2 are the seperator. For instance:
Membermaster-mbrno 12345678 = Memberdetl-mbrno 12345678. but memberdetl-mbrsep can = 123567801, 1234567802, 1234567803 etc. I want to read thru all the mbrseps and if any have a mbrfee > 0 I want to throw that record away and go read the next table A record until eof --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
