How to combine Two selected datas

Question

Iam selected two types of data from some tables.

My data is

Date                               OpenWt  StWt  ... etc

2011-05-13 00:00:00.000  -10.000  0.000 0.000 0.000 6.000 0.000 0 0 0 0
2011-05-13 00:00:00.000  -10.000  0.000 7.000 0.000 0.000 0.000 0 0 0 0

i want join this data by date, it is same date, join same date into one rows.

These date are different table date, say one is Sales bill date other one is purchase bill date.


Lastly if it is same date show only one row.. how possible?

my code is attached with this...