Question

SQL语法错误，VB access 数据库 中提示 from 子句语法错误，代码如下，请高手指点 在线等。

Private Sub Combo5_Click()
Set conn = CreateObject("adodb.connection")
Set rs = CreateObject("adodb.recordset")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.Path & "\NXRYINF.mdb"
rs.Open "select * from shixianbh, station where shixianbh.市县ID=station.市县ID and shixianbh.市县='" & Combo5.Text & "'", conn, , , adCmdTable
Do While Not rs.EOF
Combo6.AddItem rs("作业点简称")
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
Set conn = Nothing

End Sub

Answer 1

from 表1 inner join 表2 on 表1.字段 = 表2.字段

where ……………………
表一表二中需要有关联字段，用来关联两表。（表2.字段、表1.字段需要是关联字段）