Sanjeet
asked on
SQL with more then 1 value for returning data from a field
I need to return the user id for specific users from a table
such as
select OBjectID, from PTUsers
where LoginName = 'metatree\jmajorve'
AND LoginName = 'metatree\jkarasek'
such as
select OBjectID, from PTUsers
where LoginName = 'metatree\jmajorve'
AND LoginName = 'metatree\jkarasek'
USE DISTINCT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select OBjectID from PTUsers
where LoginName in ( 'metatree\jmajorve' , 'metatree\jkarasek' )
where LoginName in ( 'metatree\jmajorve' , 'metatree\jkarasek' )