SELECT StringMap.Value,*
FROM StringMap
INNER JOIN MetadataSchema.Entity
ON StringMap.ObjectTypeCode = MetadataSchema.Entity.ObjectTypeCode
WHERE
StringMap.AttributeName Like 'address1_addresstypecode'
AND MetadataSchema.Entity.Name Like 'account'