Hi My sql is like this and it gives me an nullPointerException what might be the problem please help
select org.orgName,appraisal.appraiser, appraisal.appraisee, staticdata.name as deptname from org, staticdata, hruser, appraisal where staticdata.id = hruser.deptname and hruser.userid = appraisal.appraisee group by hruser.deptname
At a quick � second look at your SQL I can't see a problem with it; I presume it runs all right from the command line? A NullPointerException (NPE) doesn't occur in SQL code at all; it occurs in the Java code which you haven't provided. Go to the beginner's forum and do a search for NullPointerException and you find threads like this one, which has links to older threads. Go through them and you will know more about NPEs, to help you solve your present problem.