I did this once. I had to get a SQL guru buddy of mine to pitch in. Let me see if I can't dig out the query and regurgitate it for you.
At 05:35 PM 3/26/2003 -0500, you wrote: >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) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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.
