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
Waseem