selva kumar

selva kumar

  • NA
  • 557
  • 189k

How to Join two tables?

Mar 6 2014 3:43 AM
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.

Answers (5)