摘要:
A common, standard SQL way of doing this is:UPDATE dest_table t1SETfield1 = (select field1 from src_table t2 where t2.pk = t1.pk),field2 = (select field2 from src_table t2 where t2.pk = t1.pk),...etc.WHERE EXISTS (select 1 from src_table t2 where t2.pk = t1.pk)If you are using Firebird 2, you can us 阅读全文