如何用c#编写SQL语句来连接数据

我试图从不同的表连接数据，并在数据网格中显示它们，但我得到一个错误。

我正试图从那些表中得到这些信息。顺便说一句，用户需要输入他的id。

保留

" + this "。UserID + "是用户的实际ID (int)

bookingID: 1 (int)

bookID: 3 (int)

userID: 1 (int)

Name: Jack (string)

LastName: Jones (string)

书

NameOfTheBook: the Lord of the Rings (string)

结果

1,3,1杰克·琼斯，指环王(在数据网格表中)

string Query = 
    "SELECT bookingID, bookID, userID, Name, LastName, NameOfTheBook " + 
    "FROM Reservations, Users, Books "+
    "WHERE userID = " + thisUserID.Text + 
    " AND Users.ID = " + thisUserID.Text + 
    " AND Books.ID = " + thisUserID.Text + "";

误差

至少有一个必需参数的值尚未确定

我该如何修复它?

string Query = 
"SELECT bookingID, bookID, userID, Name, LastName, NameOfTheBook " + 
"FROM Reservations, Users, Books "+
"WHERE userID = " + thisUserID.Text + 
" AND Users.ID = Reservations.userID"
" AND Books.ID = Reservations.bookID";