0

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.....

3
Contributors
3
Replies
6
Views
5 Years
Discussion Span
Last Post by Ezzaral
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.