rouhparvarmehdi
دوشنبه 10 اردیبهشت 1397, 00:55 صبح
سلام این کد منه خطای Inner میده چرا؟
cmd.CommandText = "Select Tbl.Darkh.Dr_az,Tbl_phone.Type,Tbl_phone.phone,Tbl _phone.Dr" +
"from Tbl_Darkh Inner Join Tbl_phone" +
"on Tbl_Darkh.Number=Tbl_phone.Number and Tbl_Darkh.Date_d=Tbl_phone.Date_d and Tbl_darkh.Codemeli=Tbl_phone.Codemeli" +
"Where Tbl_Darkh.Date_p Between '" + bPersianCalenderTextBox16.Text + "' and '" + bPersianCalenderTextBox17.Text + "'";
------------------------------------
خطای مورد نظر :
System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'Inner'.'
cmd.CommandText = "Select Tbl.Darkh.Dr_az,Tbl_phone.Type,Tbl_phone.phone,Tbl _phone.Dr" +
"from Tbl_Darkh Inner Join Tbl_phone" +
"on Tbl_Darkh.Number=Tbl_phone.Number and Tbl_Darkh.Date_d=Tbl_phone.Date_d and Tbl_darkh.Codemeli=Tbl_phone.Codemeli" +
"Where Tbl_Darkh.Date_p Between '" + bPersianCalenderTextBox16.Text + "' and '" + bPersianCalenderTextBox17.Text + "'";
------------------------------------
خطای مورد نظر :
System.Data.SqlClient.SqlException: 'Incorrect syntax near the keyword 'Inner'.'