Perhaps you can use SELECT TOP in the subquery ... select userid from bids where bid= (select top 1 bid from proxy where bid > 5)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Dinowitz Sent: Wednesday, March 26, 2003 5:35 PM To: SQL Subject: single return sub queries I've got a sub query that may return 2 or more rows. This is illegal in a sub query so I'd like to limit it to just one. Is there any modifier for the sub query to say 1 row only? Using this as an example where the select bid is what I'd like to limit. select userid from bids where bid= (select bid from proxy where bid > 5) Thanks Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
