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 ?
