您当前的位置: 表table1(id1,date),table2(id1,id2,fd2)
当给的条件日期tmpdate在table1能找到时(即select count() from table1 where date=tmpdate不为空记录)，更新和table1里对应的id1字段对应的table2里的fd2字段值为‘aaa’,如果没有找到时，更新为‘bbb’。
怎样写语句，求解！！！
------解决方案--------------------
- SQL code
declare row_count int default 0;
select count(*) into row_count from(
select * from table1 where date = tmpdate fetch first 1 row only
);
if row_count > 0 then
update table2 set fd2 = 'aaa';
else
update table2 set fd2 = 'bbb';
end if;
------解决方案--------------------
- SQL code
update table2 set fd2 = 'aaa'
where exists(
select id1 from table1
where table1.id1 = table2.id1
and table1.date = tmpdate
);
update table2 set fd2 = 'bbb'
where not exists(
select id1 from table1
where table1.id1 = table2.id1
and table1.date = tmpdate
);