I have two tables, one is a student and the other promotion_student. I want to copy Student's data for promotion_student. I wrote this query.
str = "INSERT INTO [promote_student] SELECT * FROM [Student] OR [SrNo]= "& row.Cells (" sr_no "). Value &" and [session]= "& from_session.Text &" " cmd = New OleDb.OleDbCommand (str, cn) da.SelectCommand = cmd da.Fill (ds, "favor_student")
Here sr_no is a unique value and from_session is & 2018-2019 & # 39; but this request does not copy anything and gives no error.