Insert into values and select statement
Posted on 2008-10-28
I'm using MS Access as the DB, Visual Studio VB.net as the interface and I'm trying to run the following SQL Statement
sSql = "Insert Into TEMPIN(IDSTAT,FECHACON)"
sSql += " Values(2,'" & dtfecha & "');"
sSql += " Select * FROM MASTER"
sSql += " WHERE CB = '" & strLine & "' and IDSTAT = 1 "
If Con.State = ConnectionState.Closed Then Con.Open()
cmd = New OleDb.OleDbCommand(sSql, Con)
What I want to achive is Insert all field from "MASTER" table into "TEMPIN" table where both tables are identical, plus a 2 value fields from different variables
Is this posible to mix the VALUE and SELECT in a INSERT INTO SQL Statement