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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update Query
- Thread starter eshaan
- Start date
Something like this ?
UPDATE tblinformation INNER JOIN tblmaster ON tblinformation.id = tblmaster.id
SET tblinformation.[product field] = tblmaster.prodct;
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
UPDATE tblinformation INNER JOIN tblmaster ON tblinformation.id = tblmaster.id
SET tblinformation.[product field] = tblmaster.prodct;
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
- Status
Similar threads
- Locked
- Question
- Question