SELECT
       ['Workflow Step Instance Table'].Workflow_name
       ,['Workflow Step Instance Table'].WF_Step_Predecessor
       ,['Workflow Step Instance Table'].Workflow_Step_Name
       ,['Workflow Step Instance Table'].WF_Step_Description
       ,['Workflow Step Instance Table'].EmailMessageID
       ,['Workflow Users'].ADLogin
       ,['Workflow Users'].ADDisplayName
FROM
WF100002 as ['Workflow Master'] LEFT JOIN
       WF100003 AS ['Workflow Step Instance Table']
	  on
	  ['Workflow Master'].Workflow_Name = ['Workflow Step Instance Table'].Workflow_Name

LEFT JOIN
       WF40200 AS ['Workflow Users']
ON
       ['Workflow Step Instance Table'].Workflow_Step_Assign_To = ['Workflow Users'].UsersListGuid
	   where ['Workflow Master'].ACTIVE = 1