Question

求助！请高人使用正则表达式把下面的sql文的表名，项目名提出来

SELECT
b.BANKCD,
b.BANKNM,
BANKSNM,
(
SELECT
count( k.BANKCD)
FROM
BANKSMST1 k,
BANKSMST2 l
WHERE
k.BANKCD = 0001
AND l.BANKCD = 0001
AND rownum = 1
)
FROM
(
SELECT
c.BANKCD,
c.BANKNM,
e.BANKSNM,
g.BANKNMK
FROM
BANKMST3 c,
BANKSMST4 e,
(
SELECT
f.BANKNMK
FROM
BANKMST5 f
WHERE
f.BANKCD = 0001
) g
WHERE
c.BANKCD = 0001
AND c.BANKCD = e.BANKCD
) b,
BANKMST6 d
WHERE
b.BANKCD = 0001
AND b.BANKCD = d.BANKCD

Answer 1

Private Sub Form_Load()
Dim dat(14) As String
Dim i As Integer, ii As Integer, iii As Integer
Dim x As Integer
For i = 5 To 1 Step -1
For ii = 0 To 5 - i
dat(iii) = x + ii
iii = iii + 1
Next
x = dat(iii - 1) + i
Next
MsgBox Join(dat, ",")
End Sub

Answer 2

你先把你最后取得的形式写出来吧

Answer 3

好难