Error SQL and Crystal Reports

I am not sure about the error. But could you please try by creating a View and use in Crystal report