Bryan Stevenson wrote: > sub-queries can only return one record....thus the error
Actually Bryan, that's not true. Sub-queries can only return one column. SOME subqueries can only return one record - others can return multiple records. That's why my original response was to ask what exactly the query was. Example of a subquery that can only return ONE record: select name from emp where id = ( select id from hr where socnum='123456789' ); Example of a subquery that can return MULTIPLE records: select name from emp where id IN (select id from hr where socnum like '12345%'); Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240458 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
