I'm pretty sure that what I'm trying to do is not rocket science.
This select returns no rows from my database when I think it should.

select
b.lworefid,
a.COMPANYNAME,
a.CONTACT,
a.ADDRESS,
a.CITYPROVINCE,
a.POSTALCODE,
a.PHONE,
a.FAX,
a.CELL,
a.EMAIL,
a.memberid
from
industrylwoexpressions a,
industrylwo b
where
b.lwoid in (select distinct lwoid from industrylwoexpressions where
bidawarded in (0)) and
b.lwoactive in (0, 1)
order by
b.lwoid,
a.companyname

The subselect (select distinct lwoid from industrylwoexpressions where
bidawarded in (0)) returns a result of 3 and if I enter
the 3 inplace of the subselect the query runs as I would have expected
it to, with the subselect.

Is there something wrong with the entire select statement?
I've used the IN operator before so I though this would have worked
with out a problem.

I think I've been looking at the problem for too long.

Any suggestions would be greatly appreciated.

Ryan.