Home >
Programmer2Programmer.NET Forum>
ASP.NET, MVC and Web Development >> how to get rid of repeating row labels in mysql query result set...
NOTE : Log In required to post Replies for this discussion.
|
how to get rid of repeating row labels in mysql query result set
|
|
Waseem
|
Posted: Monday 29, July 2019 02:43:57 AM
|
|
|
I have two tables named customers with primary key cid and inst
allment with foreign key cid. i join both table. Result set con
tains repeating items labels.But i want result set do not conta
in repeating items labels. explanation as under
custom table
cid name cell
12 Ramzan 033333
15 zahid 034444
21 Shahid 035222
installment table
cid amount date
12 1500 12-05-19
15 1500 13-05-19
12 1500 15-05-19
15 1500 17-05-19
21 2000 20-05-19
Resultant table
cid name cell date amount
12 Ramzan 03333 12-5-19 1500
12 Ramzan 03333 15-05-19 1500
15 Zahid 03444 13-05-19 1500
15 Zahid 03444 17-05-19 1500
21 Shahid 035222 20-05-19 2000
But i want to get this resultant Table
cid name cell date amount
12 Ramzan 03333 12-5-19 1500
15-05-19 1500
15 Zahid 03444 13-05-19 1500
17-05-19 1500
21 Shahid 035222 20-05-19 2000
total 8000
But i want to get this resultant Table
cid name cell date amount
12 Ramzan 03333 12-5-19 1500
15-05-19 1500
15 Zahid 03444 13-05-19 1500
17-05-19 1500
21 Shahid 035222 20-05-19 2000
total 8000
|
|
Back to Top
^ |
|
|
|
Home > Programmer2Programmer.NET Forum >ASP.NET, MVC and Web Development >> how to get rid of repeating row labels in mysql query result set...
|