update table_2 a inner join table_1 b on a.id=b.id set a.p_id=b.p_id where b.department_id=12
谢谢#3楼,刚刚又调试了sql应该是: update drug a inner join drug1 b on a.drug_name=b.drug_name and a.drug_producer = b.drug_producer set a.drug_number=b.drug_number where b.department_id= 26 and b.drug_number <> 0谢谢,结贴!
table_2[id,name,p_id,depaertment_id,number];
意思是 两表的 结构一样,内容也一样,只是某一字段值 number不一样。 现在要从table_1中查询出来 department_id = 12的所有内容的字段 number值,然后 更新到 table_2的 number里面,用p_id 关联就可以(table_1.p_id = table_2.p_id)
set a.p_id=b.p_id
where b.department_id=12
update drug a inner join drug1 b on a.drug_name=b.drug_name and a.drug_producer = b.drug_producer set a.drug_number=b.drug_number
where b.department_id= 26 and b.drug_number <> 0谢谢,结贴!