Is there an equivalent in Access/SQL2k?
> if you're using Oracle you can do > > SELECT userid > FROM bids > WHERE bid= (SELECT bid FROM proxy WHERE bid > 5 AND ROWNUM < 2) > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 26, 2003 2: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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
