Syntax Error In FROM Clause - Help Needed Please!!

 Hi all,
I am a newbie to asp and have been using VWD to make a database for an assignment but I am having big problems trying to extract some data to a datalist view. I intend to use this page to display all information of hotel rooms. I know its probably really obvious to some of you but its driving me mad!!! Any help would be greatly appreciated.

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim ds As New DataSet()
        Dim sGetRooms As String = "SELECT RoomID, RoomType, " _
          & "RoomName FROM Rooms2 " _
          & "WHERE RoomType LIKE @RoomType " _
          & "ORDER BY RoomType"
        Dim sGetroomsizeandprice As String = "SELECT ID, RoomSize, RoomPrice, @RoomType " _
          & "FROM roomprices JOIN Rooms2 ON Rooms2.ID = roomprices.ID " _
          & "WHERE RoomType LIKE @RoomType " _
          & "ORDER BY RoomPrice"
        Dim sConnect As String = ConfigurationManager.ConnectionStrings("White Sand's Hotel - Dan MahilConnectionString").ConnectionString

        Using con As New OleDbConnection(sConnect)
            Dim da As New OleDbDataAdapter(sGetRooms, con)
            Dim param As New OleDbParameter("RoomType", OleDbType.VarChar, 10)
            param.Value = Request.QueryString("RoomType") & "%"
            da.SelectCommand.Parameters.Add(param)
            Try
                da.Fill(ds, "Rooms2")
                da.SelectCommand.CommandText = sGetroomsizeandprice
                da.Fill(ds, "roomprices")
            Catch ex As Exception
                Label4.Text = "ERROR: " & ex.Message
                Exit Sub
            End Try
        End Using
        Dim pkcol As DataColumn = ds.Tables("Room2").Columns("RoomID")
        Dim fkcol As DataColumn = ds.Tables("roomprices").Columns("ID")
        Dim dr As New DataRelation("MenuLink", pkcol, fkcol)
        ds.Relations.Add(dr)
        DataList1.DataSource = ds
        DataList1.DataMember = "Rooms2"
        DataList1.DataBind()
    End Sub