Archives of the TeradataForum
Message Posted: Fri, 02 Jan 2009 @ 16:37:26 GMT
| Subj: || || Re: IN clause limt |
| From: || || Anomy Anom |
<-- Anonymously Posted: Fri, 2 Jan 2009 11:13 -->
As others have noted, there is no limit on the number of ROWS returned by the subquery. If you are getting the "3607 Too many values in a
subquery" error, it means the subquery returns more COLUMNS than were specified on the left side of the IN condition. Re-check your actual syntax;
if you still can't see the problem, post the actual SQL here.