>>Select >> Case When Empty(Activejobitems.part_no) Then >> Activejobitems.description >> Else Activeparts.description End as description >>From JobItems >>Activejobitems Inner Join Jobs Activejobs On Activejobitems.job_num = Activejobs.job_num >>Left Outer Join parts Activeparts On Activejobitems.part_id = Activeparts.id Inner >>Join schedule On Activejobitems.job_num = ScheduleRecords.job_num >>Inner Join machines On ScheduleRecords.mach_num = Machines.mach_num >>Where ScheduleRecords.mach_num = ' ' AND >> ScheduleRecords.status <> 'C' AND >> Activejobs.status = 'A' >>Order By [ScheduleRecords].[mach_num] , [ScheduleRecords].[order_mach] >>