J
JUMP1972
Unregistered / Unconfirmed
GUEST, unregistred user!
70分另20分在另一个贴子)哪位高手帮帮我??? 如何用一个表的字段更新另一表的字段(Informix数据库)?在PB中此语句该怎么写?(50分)<br />SQL Server 2000语句如下:
update account_list set client_id=client_list.client_id from client_list
where account_list.stat_id=client_list.stat_id and
account_list.village_id=client_list.village_id and
account_list.account_name=client_list.client_name
update account_list set client_id=client_list.client_id from client_list
where account_list.stat_id=client_list.stat_id and
account_list.village_id=client_list.village_id and
account_list.account_name=client_list.client_name