update phar_medi_main,phar_checkup_temp set phar_medi_main.medistore=phar_medi_main.medistore-phar_checkup_temp.phar_temp_num where phar_medi_main.medino=phar_checkup_temp.medino以上的SQL语句有什么问题?
要实现phar_medi_main中满足phar_medi_main.medino=phar_checkup_temp.medino的记录的medistore都被更新。
在线等待!!!
要实现phar_medi_main中满足phar_medi_main.medino=phar_checkup_temp.medino的记录的medistore都被更新。
在线等待!!!
update phar_medi_main
set a.medistore=a.mediatore-b.phar_temp_num
where
a.medino=b.medino
from phar_medi_main a,phar_checkup_temp.medino
应该可以.
set a.medistore=a.mediatore-b.phar_temp_num
from phar_medi_main a,phar_checkup_temp b
where
a.medino=b.medino
报这个错!
怎么办?
set a.medistore=a.mediatore-b.phar_temp_num
from phar_medi_main as a,phar_checkup_temp as b
where
a.medino=b.medino
set a.medistore=a.mediatore -(select b.phar_temp_num from phar_checkup_temp b where B.medino=A.medino)
set a.medistore=a.medistore-b.phar_temp_num
from phar_medi_main a,phar_checkup_temp b
where a.medino=b.medino
这样就匹配了。
我有和你同样的问题,帮你推一下。
update table2 set name=(select table1.name from table1 where table1.id=
table2.id) where if exists (select * from table1 where table1.id=table2.id)
update phar_medi_main
set a.medistore=a.medistore-b.phar_temp_num
from phar_medi_main a,phar_checkup_temp b
where a.medino=b.medino
set medistore=medistore-b.phar_temp_num
from phar_medi_main a,phar_checkup_temp b
where a.medino=b.medino这样行不行?