By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,694 Members | 1,847 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,694 IT Pros & Developers. It's quick & easy.

need help get All matching experience in all category with min query

P: 1
any one can help me to get correct with min query to get All matching experience in all the category mentioned in condition.

If my table structure like...

Field Type
================================
UserCatId int(11)
UserId int(11)
CategoryId int(11)
Experience int(11)

And; I have to findout the users who have matching experience in all the category mentioned in condition.

i.e.: Any user who have experience in Category Id 1 between exp. between 10 to 15 yrs. As well as CategoryId 2 between experience of 5 and 8 yrs.
and more...

I want to achieve this; could you please suggest me the Query or if any modification required in database Table Structure ?
Apr 16 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.