Skip to content
Advertisement

combining data from two tables with same primary key

I have a table like this:

and another table like this:

I want to INSERT the locations into the table1 ON t1.id=t2.id so table1 looks like this:

For some reason though, when I run

I get a syntax error. Does anyone know how to insert it correctly?

Advertisement

Answer

Actually you want to update Table1:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement