Bonnie I tried your suggestion but still the answer is not correct
any advice....
Elahe
select s.text,b.bugNumber,b.bdesc,b.submittedDate,b.fixedDate,b.userID,b.contact,u.name from bug b, user u, statusDesc s where b.ID=s.ID and b.userId=u.userId and s.text != 'open' and u.name= 'JDR'