469,601 Members | 2,329 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,601 developers. It's quick & easy.

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

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
0 1463

Post your reply

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

Similar topics

1 post views Thread by Bola | last post: by
5 posts views Thread by jim_geissman | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.