how to get different columns by joining two tabl : Problem:

I am trying to join table1 and table2 to get the wk_nmbr for begin_date and end_date. 


**table1**
begin_date,
end_date

**table2**
cal_date,
wk_nmbr

**Condition:** 
table1.begin_date=table2.cal_date and
table1.end_date=table2.cal_date

**expected result in table 3:**
begin_date,
wk_nmbr_begin,
end_date,
wk_nmbr_end,



