sqlstr ="INSERT INTO partylinks ( accountid, partyid ) values(Select max(accountsinfo.accid) FROM accountsinfo,2 )"" cmd = New OleDb.OleDbCommand(sqlstr, con, tra) cmd.ExecuteNonQuery() tra.Commit()
INSERT INTO tablename (columns) SELECT (columns) from tablename
INSERT INTO partylinks ( accountid, partyid ) Select max(accountsinfo.accid),2 FROM accountsinfo -- moved the ,2
INSERT INTO TARGET_TABLE_NAME(Field1, Field2) SELECT Field1, Field2 FROM SOURCE_TABLE_NAME
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)