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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need help to create my query
- Thread starter 6183
- Start date
A starting point:
SELECT G.*
FROM ([Grp/usr] G
LEFT JOIN usrJPE J ON G.[usr ID] = J.[usr ID])
LEFT JOIN usrEMS E ON G.[usr ID] = E.[usr ID]
WHERE (J.[usr ID] Is Null Or E.[usr ID] Is Null)
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
SELECT G.*
FROM ([Grp/usr] G
LEFT JOIN usrJPE J ON G.[usr ID] = J.[usr ID])
LEFT JOIN usrEMS E ON G.[usr ID] = E.[usr ID]
WHERE (J.[usr ID] Is Null Or E.[usr ID] Is Null)
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
- Status
Similar threads
- Locked
- Question
- Question