Jump to content

How to update a field from another table'sfield when id are the same


hoverinc

Recommended Posts

Hello everybody

I have a 1table with 2 fields (id, text) the 2table have (id,text) i want to update the 1table(text) from 2table where 1table.id=2table.id

 

I have tried like this

update 1table set test= test where 1table.id=2table.id

 

Hope to have some ideas regarding with thanks in advance

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.