Could someone help me with this?
ins.CommandText = " INSERT INTO CoupleTbl (acntId, kasal, spouseName) " &
"SELECT (acntId, " & dtpMarriage.Value & " , '" & txtSpouseName.Text & "') FROM AccountsTbl INNER JOIN " & "CoupleTbl ON AccountsTbl.acntId = CoupleTbl.acntId);"
ins.CommandType = CommandType.Text
ins.Connection = con
ins.ExecuteNonQuery()
MsgBox("Record Inserted")
error says : Syntax error (comma) in query expression '(acntId, 5/17/2013 , 'Last , First, Middle')'