Hello. I'm trying to create an append query that would handle the following table structure... I'm looking to take records that look like:
(Record1) InvoiceID (KEY) PayoutType1 PayoutAmount1 PayoutType2 PayoutAmount2 PayoutType3 PayoutAmount3 (END Record1) Where each record has multiple payment types for a single invoice. Instead, I'd like to have another table that handles just payment types/amounts and where it could have many records (multiple payment types/amounts) for a single invoice instead of trying to create an indexing field based on a finite set of payments) Instead, I would like this: (Record1) PaymentId (KEY) InvoiceID PayoutType PayoutAmount (END Record1) (Record2) PaymentId (KEY) InvoiceID PayoutType PayoutAmount (END Record2) (Record3) PaymentId (KEY) InvoiceID PayoutType PayoutAmount (END Record3) I may be in the wrong group. I spent 60 minutes trying to find the right group and if I didn't find it, I assure you I don't mean to intrude... but I'm a bit stuck on this business project. -- 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 oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en To unsubscribe from this group, send email to oracle-plsql+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
