现有两张表hz_qyhznr bf_qyhznr
关联条件hz_qyhznr.nbxh=bf_qyhznr.nbxh
hz_qyhznr 主键：nbxh
bf_qyhznr 主键: nbxh bfxh
现在需要从bf_qyhznr取出一条数据，将其中的字段clrq,jyqsrq 赋值到hz_qyhznr中对应字段
取的bf_qyhznr数据要求：bf_qyhznr.bfxh最大
------解决方案--------------------
------解决方案--------------------
select max(bf_qyhznr.bfxh),
bf_qyhznr.clrq,bf_qyhznr.jyqsrq
from hz_qyhznr,bf_qyhznr
where hz_qyhznr.nbxh=bf_qyhznr.nbxh
group by bf_qyhznr.clrq,bf_qyhznr.jyqsrq
------解决方案--------------------
