|| ' was paid on' || :new.paydate);测试它:set status=2car_ticket表:cid int, --- the car that violated parkingregulations
lid int, --- lot where violation took
b.ClientID and b.CurrencyID = f.CurrencyID and b.IsActive = 1
on b.TID= g.TID
on a.ClientID = d.ClientID and d.CurrencyID = f.CurrencyID andclient1,OrgNamecurrencyid,cname2,R