Hi what can be the problem with this sql it gives me an sqlException please help
Select staticdata.descr as deptname, hruser.deptname as deptid from appraisal, measureimpact, measuretype left join measure on measure.measuretype = measuretype.meastypeid left JOIN hruser on hruser.userid = appraisal.appraisee LEFT JOIN staticdata on staticdata.id = hruser.deptname where hruser.deptname and appraisal.lastupdated AND appraisal.lastupdated group by deptname
posted 8 years ago
Does that run from the command line? There seems to be something missing after WHERE; you ought to have = or > or < or IS NULL or something similar.