Jeff, It just means that your sub-query can return more than one row, which a subquery used in comparison or selection cannot... Just selec the TOP 1 to make sure this doesn't happen. It it is NOT supposed to happen, then you have bad data or are not using all required criteria (ie. is_deleted = 0, is_active = 1, etc).
select * from users1 where username = (select TOP 1 name from users2 where firstname = 'Jeff'') ....................... Ben Nadel www.bennadel.com -----Original Message----- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 3:35 PM To: CF-Talk Subject: Okay, here's *another* error message I've never seen... [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] At most one record can be returned by this subquery. What on earth? Admittedly, this isn't my code, but I'm tasked with figuring out why it's generating that error message...what, philosophically, would cause that? -- Jeff Small LHWH Advertising Myrtle Beach, SC 29577 843-448-1123 Ext 254 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240399 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
