Yes, this is a strange one. Lets say I have a list of 10 keywords. I can select all items that have one of the keywords. Some items will have a lot, some items a few, and some items none. I'd like to get 2 rows returned per keyword.
So a keyword of spam returns 3 rows, a keyword of ham returns 0, and a keyword of lamb returns 10. I want a single query which will get me 2 spam and 2 lamb. Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3387 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
