access 自動編號復位

Access自動編號復位
ALTER TABLE  Admin alter COLUMN [ID] COUNTER (1, 1)

將一個表的數據復制到另一個表
insert into newtablename select * from tablename

insert 新表(column1,column2.......)
select column1,column2..
from 舊表

update的兩種用法

update table2 set adr = (Select top 1 address from table1 where table1.id = table2.id)

update table2,table1 set table2.adr = table1.address where table1.id = table2.id