Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Join data and Update Question
Using this information could I ask if anyone could show me what the script would be to get the correct results. I am trying to take information from two tables that have a common ID number. When they match to create a new record in a third table. I have 3 tables: Accountproduct Contract... -
Update a Field from a Join
Thank you as that did work! Only problem now is I can not seem to link the data. I guess I need to have a line of code that copies the "ClientID" into the new table called IGC_EmailStatus. This is very frustrating as all I wanted to do was update a remove or add to newsletter field... -
Update a Field from a Join
I was trying to find a solution to update a field "removewebzine" with a "T" but so far it works like two separte requests. Does anyone know what I can do to have it find a match then update the field? SELECT IGC_EMAILSTATUS.EMAIL FROM IGC_EMAILSTATUS INNER JOIN...
