Seeing as I am not the best with SQL and I was having a big time trouble with this I thought I would come here for some help. I have two tables with names in both two columns and want to update one table with the names of any new names in the other table. I have tried the following code and many versions of such.
Please help. and yes this is not the best SQL code and thats why I came here.
Insert Into 2003(Name)SELECT User_Name FROM Qry WHERE (Name FROM 2003)<>(User_Name From Qry)
Also used the same code cept for UPDATE where Insert Into, and also changed Where statement to a couple other things.