Hemant Kumar

Hemant Kumar

  • NA
  • 10
  • 18.5k

how to update more than two columns of one table depending upon different value of another table??

Jul 31 2012 3:51 AM
suppose i have one table ShiftMaster in this i have columns shiftname and shift code is there, another table i have shiftroster where sunday monday.... are columns for each day i am selecting shiftname n saving its corresponding shiftcode in database now i am updating shiftcode in shiftmaster and i want that changes affect in my shiftroster also for that  day only  shiftcode should be changed  where that shiftname is assigned 

Answers (3)