Insert Into + Join Question

declare @errors table (

erroriD varchar (20),
errorMessage varchar (100))

insert @errors select '1', 'unable to resolve address'
----------------------------------------------------------------------------------------------------------------------------------------

declare @addressLookup table (

address varchar (100))

insert @addressLookup
select'water'union all
select'apple'
----------------------------------------------------------------------------------------------------------------------------------------

declare @exception table (

address varchar (100),
errorID varchar (100))
----------------------------------------------------------------------------------------------------------------------------------------

declare @address table (
addressName varchar (100)
)

insert @address
select 'route 50 st'union all
select 'pine heaven st'union all
select 'banana st' union all
select 'apple st' union all
select 'sand st'

----------------------------------------------------------------------------------------------------------------------------------------

insert @exception (address, errorID)
select substring(a.addressName, 1, charindex(' ', a.addressName)), e.errorID
from @address a, @errors e
where substring(a.addressName, 1, charindex(' ', a.addressName)) not in
(select address from @addresslookup al)
and e.errorID ='1'

select * from @exception
----------------------------------------------------------------------

If the addressName is not in the @addressLookUp table. This addressName should be insert into the @exception table with the correct errorID from @errors.
i wrote the code but 'Pine heaven' and 'route 50 'is not showing.