用查詢來update

• update 表格1,表格2... set... where

• update largehost,IP set largehost.欄位2 = IP.ID where largehost.欄位1 > Left(IP.ip,InStr(IP.ip,"-")-1) and largehost.欄位1 < trim(Mid(IP.ip,InStr(IP.ip,"-")+1));