I have three tables in my db.
Table A
has the fields
KEYID | KeyName
27 | Income
28 | Account Number
Table B
has the fields
UserID | Email | Name | Phone
481 | test@gmail.com | test | 99999999
Table C
has the fields
ID | KEYID | UserID | Value
1 | 27 | 481 | 10,000
I need to display the table fields headers are:
UserID | Email | Name | Phone | Income
and the table values should be like this:
481 | test@gmail.com | test | 99999999 | 10,000
I can get the KeyIDs which should be displayed in the table. In this example the KeyIDs string is '27' . I tried with joining and i can fetch & display the value in the table. but i dont know how i can show the key name as table header.
Any Idea.?