我在一个名为ja_jobs的表上有一些重复的行:select * from ja_jobs WHERE clientid = 33731 AND creatortype = 'legacyrec' AND deleted = false AND time_job IS NOT NULL AND (time_job,recurrenceid) IN (
select time_job,recurrenceid FROM ja_jobs WHERE clientid = 33731 GROUP BY time_job,recurren
,AMIB.Description,AMIC.Description,AMID.Description,AMIE.Description) LEFT JOIN JDJDA.OEMPartNumber ON JDA.OEMPartNumber = AMIA.OEMItem LEFT JOIN amipartnumbers as AMIB
ON JDB.OEMSubNumber = AM