try this!!

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 XX.lwoid from industrylwoexpressions XX
where XX.bidawarded =0 )
and
( (b.lwoactive =0) OR (b.lwoactive =1))
order by
b.lwoid, /****** b.lworefid ******/
a.companyname

> 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