[office politics]

stepdefinition has
steptype
flowid
stepid

task has
taskid
flowid
stepid

flowid and stepid for both tables match; meaning that if i found a record in task with a certain taskid, i could query stepdefinition with the same flowid and stepid to find the steptype.

well, i wanna do it the other way around. I query stepdefinition to find a list of flowids and stepids for a specific steptype.

select flowid, stepid from stepdefinition where steptype = -3

Now, I want to find all taskids in task for each flowid/stepid combination

here's a visual

[office politics]

select taskid from task 
where stepID+flowID in
	(select stepID+flowID from stepdefinition where steptype = -3)
order by taskid

works

[TheHeadFL]

Why wouldn't you execute a natural join if the two values match?

SELECT s.flowid, s.stepid, t.taskid FROM `stepdefinition` s, `task` t WHERE s.flowid = t.flowid AND s.stepid = t.stepid AND s.steptype = -3