Timeline for Duplicate record arising using join tables
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 24, 2016 at 15:46 | comment | added | Shooter McGavin | I still don't follow you. Are you trying to report a record per invoice or per payment? You said, if the invoice only has one payment, then include the details. Does that mean we should only display those invoices that have only 1 payment? If not and you want to include the details from all invoices, you need a way to aggregate the values from those payments. That is unless you just want to show a line for each payment and have the details from the invoice level duplicate. Once you know that, you know where you need to apply the GROUP BY clause. | |
| Aug 24, 2016 at 4:35 | comment | added | M.I.M.F | I want Second Table design proper joining and if i return a single row for Invoice number 13 all the other multiple lines table records should display.. | |
| Aug 24, 2016 at 4:06 | comment | added | M.I.M.F | i get your answer. The thing is Invoice and InvoiceLine part is ok for that i want to retrieve payment for example for one invoice getting more than one payment through cash, card, bank deposit and cheque at the time i want to retrieve what are the payments made ex: Total net amount is 1000 cash paying 200 like wise cheque paying 800 in that 800 3 cheques are there so in need to display what are the payments made detaild... pls help me. | |
| Aug 23, 2016 at 21:53 | history | answered | Shooter McGavin | CC BY-SA 3.0 |