retrive data from three table in sqlserver : Question : Concatenate values from multiple coloumns of 3 tables and display in one coloumn.HERE date field is datetime.
I have 3 tables:
table1

date        amt1
-----------------
1-1-2016    111
2-2-2016    222
3-4-2016    111

table2:
date        amt2
-----------------
1-1-2016    101 
2-2-2016    333
2-3-2016    444
3-3-2016    456
1-4-2016    101     
3-4-2016    111     

table3:
date        amt3
-----------------

2-2-2016    001
2-3-2016    002 
3-3-2016    003
1-4-2016    555
2-4-2016    666
3-4-2016    777

Output Desired:
date        amt1     amt2    amt3
----------------------------------
1-1-2016    111     101      NULL
2-2-2016    222     333      001
2-3-2016    NULL    444      002 
3-3-2016    NULL    456      003
1-4-2016    NULL    101      555
2-4-2016    NULL    NULL     666 
3-4-2016    111     111      777
------------------------------------
TOTAL       333     1546      2004