sql - Incorrect syntax near the keyword 'inner' -

i trying display scheduled jobs name, status , description. works well, when try sort using order scheduledname, error telling me have incorrect syntax , have no idea how fix it.

select * sysjobs job  select * sysschedules   select * sysjobschedules  select      sc.name scheduledname, job.name jobname,      job.enabled jobstatus, job.description jobdescription       sysjobs job  order      scheduledname; inner join     sysjobschedules sch on job.job_id = sch.job_id inner join     sysschedules sc on sc.schedule_id = sch.schedule_id 

you use incorrect syntax. change to:

use msdb go  select * sysjobs job;  select * sysschedules;   select * sysjobschedules;  select sc.name scheduledname, job.name jobname, job.enabled jobstatus, job.description jobdescription sysjobs job  inner join sysjobschedules sch on job.job_id=sch.job_id inner join sysschedules sc on sc.schedule_id=sch.schedule_id order scheduledname