更新bom元件代码（BOM双位查询）

update bmb_file
  set bmb03 = (select liao2 from xiaolin4 where bmb01 = liao1 and bmb03 = liao3)
  where (bmb01,bmb03) in (select liao1,liao3 from xiaolin4)
    and (bmb04 is not null and bmb04<=to_date('2012/12/25','YYYY/MM/DD'))
    and (bmb05 is null or bmb05 >= to_date('2012/12/25','YYYY/MM/DD'))