Microsoft.Crm.CrmException: attributeName when using join in LINQ in Dynamics CRM Plugin

Recently I came across this error when using LINQ in CRM custom workflow activity,

Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> Microsoft.Crm.CrmException: attributeName


Below query will throw error,

Below works with out errors :)

Hope it helps!