Next step on workflow SQL query

James Mernin

HiI have this SQL statement, and would like to know how to get the next step in the map. SELECT livelink91pic.WWork.Work_WorkID, livelink91pic.WSubWork.SubWork_Title, livelink91pic.KUAF.Name AS Performer, livelink91pic.WWork.Work_DateDue_Max AS 'Completion Date', livelink91pic.WSubWork.SubWork_Status AS Status, livelink91pic.WMap.Map_ManagerID AS initiator, livelink91pic.WSubWorkTask.SubWorkTask_TitleFROM livelink91pic.WWork INNER JOIN livelink91pic.WSubWork ON livelink91pic.WWork.Work_WorkID = livelink91pic.WSubWork.SubWork_WorkID INNER JOIN livelink91pic.WSubWorkTask ON livelink91pic.WSubWork.SubWork_WorkID = livelink91pic.WSubWorkTask.SubWorkTask_SubWorkID INNER JOIN livelink91pic.KUAF ON livelink91pic.WSubWorkTask.SubWorkTask_PerformerID = livelink91pic.KUAF.ID INNER JOIN livelink91pic.WMap ON livelink91pic.WSubWork.SubWork_MapID = livelink91pic.WMap.Map_MapIDWHERE (livelink91pic.WSubWork.SubWork_Title LIKE 'UARF%%') AND (livelink91pic.WWork.Work_Status <> - 3) AND (livelink91pic.WSubWorkTask.SubWorkTask_Status = 2 OR livelink91pic.WSubWorkTask.SubWorkTask_Status = 3)ORDER BY livelink91pic.WSubWork.SubWork_TitleThanks Leo