Dear Sir,
I have two table in mysql database which as under…
Table A
±----------±----------±-----------------+
| ID | Value | other |
±----------±----------±-----------------+
| 123456 | 5 | 12 |
| 987654 | 7 | 15 |
| 456789 | 6 | 22 |
±----------±----------±-----------------+
Table B
±----------±----------±-----------------+
| ID | Type | other |
±----------±----------±-----------------+
| 123456 | 00 | 2 |
| 123456 | 01 | 6 |
| 123456 | 02 | 4 |
| 987654 | 00 | 7 |
| 987654 | 01 | 8 |
| 456789 | 00 | 6 |
| 456789 | 01 | 16 |
±----------±----------±-----------------+
Resultant Table C (After joint A and B table)
-----------±----------±--------±-----------------+
| ID | Type | Value | other |
±----------±----------±--------±-----------------+
| 123456 | 00 | 5 | 2 |
| 123456 | 01 | 5 | 6 |
| 123456 | 02 | 5 | 4 |
| 987654 | 00 | 7 | 7 |
| 987654 | 01 | 7 | 8 |
| 456789 | 00 | 6 | 6 |
| 456789 | 01 | 6 | 16 |
±----------±----------±--------±-----------------+
But i need this type of resultant table after joining two tables in mysql or sql lite database which are as under
Desired Resultant table C (after joining A and B table)
±----------±----------±--------±-----------------+
| ID… | Type | Value | other |
±----------±----------±--------±-----------------+
| 123456 | 00 | 5 | 2 |
| ---------- | 01 | - | 6 |
| ------ ---- | 02 | - | 4 |
| 987654 | 00 | 7 | 7 |
| ---------- | 01 | - | 8 |
| 456789 | 00 | 6 | 6 |
| ---------- | 01 | - | 16 |
±----------±----------±--------±-----------------+
If someone help me out i shall be really thank full.
Thank
WaseemPreformatted text