I have written the query from account record to view the profile Name for the particular user (Who have created the account record)
Which user created the account record and what is his profile name for that
select id,JDE_ship_to_account_no__c,RecordTypeId,CreatedById where CreatedById IN (select id,name,profileid form users where id = '005b0000001XwxnAAC) from account where id = '0015E00000BHkPB'
But it is showing error:
Unknown error parsing query
How can I fix this query?