public void deleteByUspsInternationalCgrSubmissionId(Integer uspsInternationalCgrSubmissionId) { JwSqlDelete st = createDelete(); st.from(ALIAS); st.using(TABLE, ALIAS); st.using(AcUspsInternationalCgrWorkOfferDb.TABLE, AcUspsInternationalCgrWorkOfferDb.ALIAS); st.where() .isEqual( AcUspsInternationalCgrWorkOfferDb.ALIAS, AcUspsInternationalCgrWorkOfferDb.USPS_INTERNATIONAL_CGR_SUBMISSION_ID, uspsInternationalCgrSubmissionId); st.where() .isEqualColumn( ALIAS, ID, AcUspsInternationalCgrWorkOfferDb.ALIAS, AcUspsInternationalCgrWorkOfferDb.USPS_INTERNATIONAL_CGR_WORK_DUPLICATE_ID); execute(st); }