db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Duncan Groenewald <dagroenew...@optusnet.com.au>
Subject Subquery Error
Date Mon, 10 May 2010 14:16:09 GMT
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




Mime
View raw message