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'

Unknown column 'pcinumber' in 'field list'

Does this column exist?

Sorry....... Thank you..... Found the answer.. column name is wrong in the table..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.