Is It Possible to Query User from Contact

Question

To query User Profile Name from Contact, It is Possible

Example Query Like : select Id,FirstName,LastName,(Select Id,Name,Isactive,Profile.Name from user) from Contact

Thanks Nagarjuna

Answer 1

Query for profiles of users

SELECT Id, Firstname, Lastname, ProfileId, Profile.Name FROM User

Query Last modified user from Contact

SELECT ID, Firstname, Lastname, LastModifiedBy.Profile.Name FROM Contact WHERE ID = :YOUR_CONTACT_ID

Query related users of contacts "Community users"

SELECT ID, ContactId, Contact.Firstname, Contact.Lastname, ProfileId, Profile.Name FROM User WHERE ContactID = :YOUR_CONTACT_ID

Answer 2

Try this :

  for( Contact c : [select Id,FirstName,LastName,LastModifiedBy.Name, LastModifiedBy.Profile.Name from Contact limit 1]){
System.debug('cont ' + c.FirstName + ' prof '+ c.LastModifiedBy.Profile.Name);    

}