Problem in counting Archived Workflow Steps

unknown_user3

I am using the following query to count "Workflow steps archived". Now the problem which I am facing here is that If a step is assigned to 2 people count is giving me 3 steps Archived. Because for multiuser assignment a subworkflow is created. And now 2 steps for Subworkflow and 1 for the Main Workflow. Can someone help me in that.select count(*) from wwork, wsubworktask where wwork.WORK_WORKID = wsubworktask.SUBWORKTASK_WORKID and WORK_STATUS = -3 order by WORK_WORKID, SUBWORKTASK_SUBWORKID

unknown_user3

More explanation with exampleI have two tables TabA and TabBe.g. select col1, col2, col3, col4 from TabA, TabB where TabA.ID =TabB.ID col1 col2 col3 col4-------------------------------2 2 AAA BBB3 3 CCC DDD4 4 EEE FFF4 1 GGG HHH4 2 III JJJNow it returns results as above. ( when 4 and 4 and also 4 & 1, 4 &2 etc it should neglect the result 4 and 4 and should display next two 4 and 1 , 4 and 2). Then count becomes OK.