combining 4 tables

[gennesis]

Hi a have 4 tables

Table A
ID   |   Data 1
---------------
1    |    A
2    |    W

Table B
ID   |    Data 2
-----------------
1    |     B
1    |     C
2    |     X

Table C
ID   |   Data 3
----------------
1    |     D
1    |     E
1    |     F

Table D
ID   |    Data 4
----------------
1    |     G
1    |     H
2    |     Z

I want to have this result

Table Result
ID	|	Data 1	|	Data 2	|	Data 3	|	Data 4
-----------------------------------------------------------------------
1	|	A	|	B	|	D	|	G
	|      null	|	C	|	E	|	H
	|      null	|      null	|	F	|      null
2       |       W       |       X       |      null     |       Z

I tried different kind of join statement but i could not achieve my desired output.

Pls help.....

[pritaeas]

Which server are you using, because you cross-posted in MySQL and MSSQL ?

[gennesis]

sorry for that im really using mysql server.

[Ezzaral]

Cross-posted here: http://www.daniweb.com/web-development/databases/ms-sql/threads/407231/1738343#post1738343

Please direct any further discussion to that thread. Closing this one.