|| ' was paid on' || :new.paydate);测试它:set status=2car_ticket表:cid int, --- the car that violated parkingregulations
lid int, --- lot where violation took
JOIN SAMPLE ON (LOT.LOT_NUMBER = SAMPLE.LOT) AND (RESULT.ANALYSIS = PRODUCT_SPEC.ANALYSIS)) WHERE LOT.LOT_NUMBER =Order by ANALYSIS, LOCATION
我需要为sample.status添加条件,