I have a select statement that I need to create that will pick one random row based on the where clause.
SELECT *FROM averyweb_items WHERE iditemscategory = 4 AND itemsstatus = 1 I can do a random function but not sure on how to implement it. I cannot figure out what I need to do. Any help is appreciated. TIA Dan Goldberg MIS Manager Lance Camper Mfg. Corp (661) 949-3322 Ext 252 www.lancecamper.com<http://www.lancecamper.com/> -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
