I had no idea that SQL could do this until I saw a friend of mine do this in one of his programs.
However, I must admit what's "convenient" here is the fact that both the UPDATE and the embedded SELECT criteria are the same in the method shown above.
INSERT INTO Polling Places(PLACE, VCFull Addr, VCAddr, VCCity, VCZip, Phone, Alias Link) Select Vote Centers.
I've written the following but there's a problem with the syntax. These two different tables will be used in my UDPATE statement examples below. Here, you're specifying in a row what fields you want updated, and then using a multi-column SELECT to provide those values.I basically need to grab values from columns in the Vote Centers Table and place them into a column with the same name in the Polling Places column IF the value of the Code Place column in the Polling Places.table = the Code Place column in the Vote Centers table. All of these columns (PLACE, VCFull Addr, VCAddr, VCCity, VCZip, Phone, Alias Link) in all records in the Polling Places table need to be updated and I'd like to do it in the most efficient way possible. I'm new to SQL and I'm still trying to figure things out.