السلام عليكم
واجهت مشكلة اثناء البرمجة في vb.net وهي انني عندما استعلم من الجداول المصممة ببرنامج access كانت تعطيني الخطأ التالي
Syntax error (missing operator) in query expression 'relationship.stu_no=student.stu_no inner join schedule on schedule.time_no=relationship.time_no'.
وحاولت ايجاد الخطأ ولم استطيع
اما الكود الذي برمجته فكان كالتالي
Dim select_student_com As New OleDbCommand
Dim ds As New DataSet
Dim adapter As New OleDbDataAdapter
Dim single_student_sql As String
single_student_sql = "select student.stu_no from student left outer join relationship on relationship.stu_no=student.stu_no inner join schedule on schedule.time_no=relationship.time_no"
select_student_com.Connection = connect_DB
select_student_com.CommandType = CommandType.Text
select_student_com.CommandText = single_student_sql
adapter.SelectCommand = select_student_com
adapter.Fill(ds, "student")
students.DataGridView1.DataSource = ds.Tables(0)