Insert into field values from 2 tables into a new table
Posted on 2011-02-26
I am looking for the most effective way to combine 4 fields from tblImport and 1 field from dbo_item into a new table tblSelected. Fields from tblImport are seqField, CustItemNum, mfgName and Qty1. The 5th field has been saved in "Dim holdItem As String" earlier in the code. The common field that was used to get the holdItem and is needed to get the data from tblImport is holdSeq which is defined "Dim holdSeq As Long". I attempted to use an "Insert into .. Select...From...Where" SQL statement but I can seem to get the syntax correct. Any suggestions would be appreciated.