Hi.. I'm getting error in my query.. while using it in oracle it is working.. But when using it in mysql it is not working.. i'm getting error as
insert into ProjectHealthReportAudit(clientid, projectid, month, year, phasesId,ACTIVITIESSUBTYPEID, ACTIVITIESARTIFACTSID,processConformance,comments, pcinumber, pciscore, colour, createddate,createdby) values ( (select clientid from client where clientName = ?), (select projectid from project where projectName = ?) , ? , ?,(select distinct phasesid from auditcolumns where phases = ?),(select distinct activitiesSubTypeId from auditcolumns where activitiesSubType = ?), (select distinct activitiesArtifactsId from auditcolumns where activitiesArtifacts =?),?,?, (select distinct pcinumber from pcinumberTable where processconformance = ?),?,?,sysdate(), (select distinct userid from users where fullname = ?))
nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'pcinumber' in 'field list'] with root cause com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'pcinumber' in 'field list'
