mona63
پنج شنبه 13 خرداد 1389, 16:12 عصر
سلام خدمت دوستان عزیزم،خسته نباشید.
من دو تا جدول دارم که می خوام توسط inner join در دستور select دو تا رو با هم ترکیب کنم و نتیجه رو در یک datagridiew ببینم.اما error زیر رو میده.علتش چیه؟
از همه متشکرم
The specified field 'id' could refer to more than one table listed in the FROM clause of your SQL statement
کدی که نوشتم اینه:
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
' Dim searchdan As String = txt.Text
Dim con As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\ado.mdb")
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand("select people_tb1.id,people_tb1.firstname,people_tb1.last name,people_tb1.phone from people_tb1 inner join dars on people_tb1.id=dars.id where lastname='" & cmb1.Text & "'and id='" & txt.Text & "'", con)
con.Open()
Dim myda As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(cmd)
Dim mydataset As DataSet = New DataSet
myda.Fill(mydataset, "mytable")
DataGridView1.DataSource = mydataset.Tables("mytable").DefaultView
con.Close()
End Sub
من دو تا جدول دارم که می خوام توسط inner join در دستور select دو تا رو با هم ترکیب کنم و نتیجه رو در یک datagridiew ببینم.اما error زیر رو میده.علتش چیه؟
از همه متشکرم
The specified field 'id' could refer to more than one table listed in the FROM clause of your SQL statement
کدی که نوشتم اینه:
Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
' Dim searchdan As String = txt.Text
Dim con As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\ado.mdb")
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand("select people_tb1.id,people_tb1.firstname,people_tb1.last name,people_tb1.phone from people_tb1 inner join dars on people_tb1.id=dars.id where lastname='" & cmb1.Text & "'and id='" & txt.Text & "'", con)
con.Open()
Dim myda As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(cmd)
Dim mydataset As DataSet = New DataSet
myda.Fill(mydataset, "mytable")
DataGridView1.DataSource = mydataset.Tables("mytable").DefaultView
con.Close()
End Sub