How to Join two tables?

Question

Hi Friend i want to merge two tables here is my table....

table 1

Brand    TotalStock   Transferred      date
xxx           100                50              06/03/2014
yyy           100                50                 06/03/2014


table 2

Brand       Transferred             available                date
xxx                50                        48               06/03/2014
yyy                50                        40               06/03/2014

Result Table:

Brand    TotalStock   Transferred             available                date
xxx           100                50                        48               06/03/2014
yyy           100                50                        40               06/03/2014

Result table should be based Date.Can anyone help me out.