Need to update data with data from another table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 tables, networkveiw1 and computers. I also have a Query that
displays only the information that I want to insert into the computers table.
I need to take the results from that query and add that data into my existing
computer table, and I don't want to add duplicates.
 
Try this --
INSERT INTO [computers] ( [Field1], [Field2] )
SELECT [networkveiw1].[Field1], [networkveiw1].[Field2]
FROM [networkveiw1] LEFT JOIN [computers] ON [networkveiw1].[Field1] =
[computers].[Field1]
WHERE ((([computers].[Field1]) Is Null));
 
Back
Top