|
|
Hey Phil, thank you again for your help. Can I bother you once more?
I am gonna use the query you suggested last, I was wondering what happens if
user hasn't selected one of the categories? Isn't this going to bring back
incorrect result?
[q][i]Originally posted by: [b][b]paross1[/b][/b][/i]
I suppose this equivalent would do the same thing.
SELECT DISTINCT e.employerID, u.UserID
FROM employer e, employer_CAT ec, User_CAT uc, employer_LOC el, User_LOC ul,
employer_DUR ed, User_DUR ud, Users u
WHERE e.employerID = ec.employerID
AND ec.CAT = uc.CAT
AND e.employerID = el.employerID
AND el.LOC = ul.LOC
AND e.employerID = ed.employerID
AND ed.DUR = ud.DUR
AND uc.UserID = u.UserID
AND ul.UserID = u.UserID
AND ud.UserID = u.UserID
Phil[/q]
|
|