Subquery Error

[Duncan Groenewald]

The following query fails complaining about the subquery returning multiple 
records even though the select query works fine on its own.

insert into TableA (ID, ParentID, IndexNo, Type, Description, ProjectCode)
select A1.NR, 
(select A2.NR from TableB A2
where A2.WBSCODE = A1.PARENTID), 
IndexNo, Type, Title, 'AAA02'
from TABLEB A1


SELECT query runs fine on its own

select A1.NR, 
(select A2.NR from TableB A2
where A2.WBSCODE = A1.PARENTID), 
IndexNo, Type, Title, 'AAA02'
from TABLEB A1

Any suggestions ?

I have also tried using a VIEW which also works fine if its just a 'SELECT * 
from TABLEB'.  But I get the same error when trying a INSERT INTO TABLEA () 
SELECT * FROM TABLEB.

Thanks

Duncan