Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hi I have a table Emname prefe
- Thread starter anilkutty
- Start date
Easy if you have two preferences for everyone.
Here are two ways to write such a query.
This can be extended to any fixed number of preferences.
BUT, if different people have different numbers of preferences then you cannot write a query that will work for everyone. You will need to write a procedure in that case.
Here are two ways to write such a query.
Code:
SELECT p1.Emname, p1.location, p2.location
FROM myLocationPreference p1
JOIN
( SELECT Emname, location
FROM myLocationPreference
WHERE preference = 2 ) p2
ON p1.Emname = p2.Emname
WHERE preference = 1
SELECT p1.Emname, p1.location, p2.location
FROM myLocationPreference p1
JOIN myLocationPreference p2 ON p1.Emname = p2.Emname AND p2.preference = 2
WHERE p1.preference = 1This can be extended to any fixed number of preferences.
BUT, if different people have different numbers of preferences then you cannot write a query that will work for everyone. You will need to write a procedure in that case.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question