Running into a wall when trying to pull info from tables similar to those below. Not sure how to approach this.

The results should have the most recent TRANSAMT for each ACCNUM along with NAME and address. 

```
   Select A.ACCNUM, MAX(B.TRANSAMT) as BAMT, B.ADDRESS from
     From TableA A inner join TableB on A.ACCNUM = B.ACCNUM

```

This is what i have so far. Any help would be appreciated.

TableA

```
ACCNUM    NAME        ADDRESS
00001    R. GRANT    Miami, FL
00002    B. PAUL     Dallas, TX 

```

TableB

```
ACCNUM  TRANSAMT   TRANSDATE
00001    150       1/1/2015
00001    200       13/2/2015
00002    100       2/1/205
00003     50       18/2/2015

```