Access更新数据

Access 更新数据

select min(sj) from yj_mnjg;

select min(sj_temp) from 监测数据;

SELECT datediff("n",#2006-01-06 00:00:00#,#2011-03-01 00:00#);

update 监测数据 set sjnew = dateadd("n",-2707200,sj_temp);

Oracle 更新数据表
update YJ_JCSJ set cysj=(select cysj from YJ_JC where YJ_JCSJ.jc_id=YJ_JC.id

select a.id,a.cbbs,a.jcyz,a.nd, a.sfcb,a.jc_id from yj_jcsj a, yj_jc b where a.jc_id=b.id order by jc_id;