SELECT oi.LineNum FROM ORDERS o INNER JOIN ROOM r ON o.OrderID = r.OrderID INNER JOIN GlobalOptions go On go.RoomID = r.RoomID LEFT JOIN OrderItems oi ON oi.RoomID = r.RoomID WHERE o.Number = 'TDT-777' UNION SELECT sp.LineNum FROM ORDERS o INNER JOIN ROOM r ON o.OrderID = r.OrderID INNER JOIN GlobalOptions go On go.RoomID = r.RoomID LEFT JOIN ServiceParts sp ON sp.RoomID = r.RoomID WHERE o.Number = 'TDT-777'< snip >