Look up CREATE VIEW in Books Online, but to help:

create view dbo.MyView

as

select

a.DIVISION,

a.SUB_UNIT,

b.Description as ReasonsReferral

from

dbo.TableA a

inner join dbo.TableB b

on (a.REASONSREFERRAL = b.ID)