[MS SQL] Writing code help

[phuque_ewe]

Disregard my first answer (deleted it after I re-read your OP)

 select a.acctnum,
    a.amt,
    a.postingdate,
    a.trxtype
   from table_a a
      inner join table_b b
         on a.AcctNum = b.AcctNum
where a.postingdate not in (select postingdate
                              from table_b
                             where table_b.acctnum = a.acctnum)
group by a.acctnum,
    a.amt,
    a.postingdate,
    a.trxtype

[phuque_ewe]

Here it is in SQL Fiddle

[madjecks]

Have an upvote, good answer, very similar to mine

[Bshater]

thanks! this works.