I used the following query to retrieve the email addresses for a mailing, and didn't notice that it returned 750 records.
select email from WEBREPORTS.dbo.WEBALLUSERS where userid in (select distinct USERID from ADSPRD.dbo.research_request_log where submitted > '2007-01-01') and email is not null The subquery: select distinct USERID from ADSPRD.dbo.research_request_log where submitted > '2007-01-01' Is not even a valid query. There is no USERID column in that table. It does not execute when run by itself. But for some reason, the whole query still runs, and just ignores the fact that the subquery isn't valid. D'Oh! DAMN SQL SERVER! DAMN SQL SERVER TO HELL! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
