HomeОбразованиеRelated VideosMore From: SQLInSix Minutes

TSQL: Update Table From Another Table

52 ratings | 11545 views
Html code for embedding videos on your blog
Text Comments (5)
Thuy Duong Nguyen (2 months ago)
mySQL seem doesn't support "FROM" in UPDATE syntax :< it appears error whenever I type FROM in
Dave Miller (3 months ago)
I need some help. I have a client table with 3 fields that will need updated. table 1 has client info and the fields needing updated are date, Session and amount. Now I think I need a form and maybe a table to input the change. For example if client does 1 work out how can I get the detail table to subtract 1 from sessions (in client table. Then when they buy more I need to be able to update table Client with Date paid, amount paid and number of sessions they paid for. HELP !!! and thanks
BigPapaMoe1 (7 months ago)
This was very helpful. Your tips helped me re-write an old cursor based stored procedure and cut the processing time from about 50 seconds to under a second!
Nour ElDein ElKhatib (1 year ago)
thanks a million , you saved my life :D :D
Scoopy Bunny (2 years ago)
very helpful for me, thaks a lots, saved my job.👍

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.