回覆列表
-
1 # pllhd43874
-
2 # lanfengz2
1、用VBA的SPLIT拆分；
2、SQL語句拆分
增加1個輔助表(lsb)，欄位ID，內容1-100000
SELECT a.*, mid(" " & A.Bh & " ",b.id1+1,instr(b.id1+1," " & A.Bh & " "," ")-b.id1-1) AS aa1
FROM tth AS A LEFT JOIN LSB1 AS B ON B.ID1
WHERE MID(" " & A.Bh & " ",B.ID1,1)=" " and instr(b.id1+1," " & A.Bh & " "," ")>0;
1、用VBA的SPLIT拆分；2、SQL語句拆分增加1個輔助表(lsb)，欄位ID，內容1-100000SELECT a.*, mid(" " & A.Bh & " ",b.id1+1,instr(b.id1+1," " & A.Bh & " "," ")-b.id1-1) AS aa1FROM tth AS A LEFT JOIN LSB1 AS B ON B.ID10;