Dear Friends, I want to get list where text is equal to open(text=open) why is not returning any thing? Thanks, Elahe ------- rs =stmt.executeQuery("select s.text,b.bugNumber,b.bdesc,b.submittedDate,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'");