Thread: DUplicate Value Insertion in database Problem

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";

Welcome to the forum! Please read this topic to learn how to post code in code or highlight tags and other useful info for new members.