vb.net无法访问sql server2005 运行时出现sql异常
debug框内的内容：
sqlexception was unhandled
Incorrect syntax near 'titles'.
提示框出现在这句：objDataAdapter.Fill(objDataSet, "authors")
有哪位大侠指点一下，我这是哪里出错了呢，代码是例题中的
下面是我的窗口的代码
Imports System.Data
Imports System.Data.SqlClient
Public Class Form1
Dim objConnection As New SqlConnection _
("server=CXC01PC08ALLEN\WINCC;database=Pubs;user id=sa;password=123456") '我不知道怎么设置用户权限，这个用户用的是已有的用户，密码是我重新设置的，在连接语句objConnection.Open()，没有提示错误
Dim objDataAdapter As New SqlDataAdapter()
Dim objDataSet As New DataSet()
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
objDataAdapter.SelectCommand = New SqlCommand()
objDataAdapter.SelectCommand.Connection = objConnection
objDataAdapter.SelectCommand.CommandText = _
"SELECT au_lname, au_fname, title, price " & _
"FROM authors " & _
"JOIN titleauthor ON authors.au_id=titleauthor.au_id" & _
"JOIN titles ON titleauthor.title_id = titles.title_id" & _
"ORDER BY au_lname,au_fname"
objDataAdapter.SelectCommand.CommandType = CommandType.Text
objConnection.Open()
objDataAdapter.Fill(objDataSet, "authors")
objConnection.Close()
grdAuthorTitles.AutoGenerateColumns = True
grdAuthorTitles.DataSource = objDataSet
grdAuthorTitles.DataMember = "authors"
objDataAdapter = Nothing
objConnection = Nothing
End Sub
End Class
[解决办法]
titles.title_id跟order by之间也少了个空格
