Hi a have 4 tables
Table A
ID | Data 1
---------------
1 | A
Table B
ID | Data 2
-----------------
1 | B
1 | C
Table C
ID | Data 3
----------------
1 | D
1 | E
1 | F
Table D
ID | Data 4
----------------
1 | G
1 | H
I want to have this result
Table Result
ID | Data 1 | Data 2 | Data 3 | Data 4
-----------------------------------------------------------------------
1 | A | B | D | G
| | C | E | H
| | | F |
Pls help.....