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]