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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
