how to write query for this purpose

We have a worktran table

WoNo	Jobno	Status
  1	01	Fullfill
  1	02	Pending
  2	01	Fullfill
  2	02	Fullfill

We need to display those WoNo having all its rows status=fulfill

In the example above, it should display only WoNo 2 because it contain all Fullfill status
We tried - select distinct WoNo from worktran where status='Fullfill' But it does not make sure that all of the rows for certian WoNo have status='Fulfill'

Thanks in advance. Received on Fri Dec 22 2006 - 00:58:44 CST