每日归档： 2014年8月11日

#UPDATE cs_request_relation_group a, cs_request_section b, voucher c
#SET c.voucher_value = a.value
SELECT c.voucher_text, c.voucher_value, a.value
FROM cs_request_relation_group a, cs_request_section b, voucher c
WHERE a.request_id IN (63,64,65) AND b.relation_id = a.relation_id
AND c.prefix=b.prefix AND c.voucher_no BETWEEN b.first_no AND b.last_no