472,119 Members | 1,799 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

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 1517

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
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.