O
OTWarrior
last night my colleague messed up big time, and one of the table has had it's
data overwritten to one value.
ie: i have 3 tables, one for the booking, one for the home, and one for the
extra details. the extra details has a list number for the home, which has
changed to one specific value. the booking has the correct home.
how can i write a query to update the extra details table and replace the
incorrect home with the correct one from the bookings table?
Any help would be crreatly apprecaited, as the swine who messed this up is
away today.
data overwritten to one value.
ie: i have 3 tables, one for the booking, one for the home, and one for the
extra details. the extra details has a list number for the home, which has
changed to one specific value. the booking has the correct home.
how can i write a query to update the extra details table and replace the
incorrect home with the correct one from the bookings table?
Any help would be crreatly apprecaited, as the swine who messed this up is
away today.