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
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communityQuery 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
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);
}