two tables with common field with dates Here i mentioned how i need output kindly any help me.
table1
table1.col1 table1.col2 table1.col2
a ab 2015-05-01 00:00:00.000
as as 2015-05-01 00:00:00.000
as asasd 2015-05-01 00:00:00.000
asd aa 2015-05-02 00:00:00.000
asd asd 2015-05-04 00:00:00.000
table2
table2.col1 table2.col2 table2.col3
asd aasd 2015-05-01 00:00:00.000
asasd asd 2015-05-01 00:00:00.000
asd asd 2015-05-04 00:00:00.000
asd asd 2015-05-05 00:00:00.000
asd asd 2015-05-31 00:00:00.000
i want select by dateswise
Date table1.col1 table2.col2 table2.col1 table2.col2
2015-05-01 00:00:00.000 a ab asd aasd
as as asasd asd
as asasd Null Null
2015-05-02 00:00:00.000 asd aa Null NUll
2015-05-04 00:00:00.000 asd asd Null Null
asd asdas Null Null
2015-05-05 00:00:00.000 Null Null sdas asds
Null Null adad asda