So here i have a database called expiringLicences which is filled with expiring licences as the software starts
My problem here is ,it is inserting the same expiring licences over and over again as the software starts and my expiringLicences table is filled with duplicate values
i have tried this code but this doesnt work
String queryString="insert into expiringlicences(LicenceNo,LicenceDate,Balance,Num berOfDaysForExpiry)"
+ " select licenceno,licencedate,Balance,noofdaysforexpiry from importlicencedetails where noofdaysforexpiry<"+(90)+" AND expiringlicences.LicenceNo<>importlicencedetails.l icenceno";