migration script [message #410316] |
Fri, 26 June 2009 03:19  |
rajasekhar857
Messages: 500 Registered: December 2008
|
Senior Member |
|
|
hi i am having tables like
EMRPatientProblems
EMRUncodedProblems
EMRLocationMaster
EMRpatientsMaster
EMRDiagnosisCodesLkup
both EMRPatientProblems and EMRUncodedProblems are having three common columns in it like
PROBLEM_DESC,PROBLEM_CODE,STATUS
if the values are same for both tables then is_coded one column in
EMRPatientProblems tahtshould be updated to 1 as of now it is 0 for all rows .how can i achieve this?
and emruncodedproblems is having group_is column where emrpatientproblems is not having and emrlocationmaster is having group_is colukm where that values shold be taken into consideration.only based on the group specific i have to update the is_coded column values to 1.please help me out in this?
|
|
|
Re: migration script [message #410318 is a reply to message #410316] |
Fri, 26 June 2009 03:42  |
Frank
Messages: 7901 Registered: March 2000
|
Senior Member |
|
|
Please take the time to rephrase your post.
Think what you want, either describe it functionally, or provide us with a test case showing your current situation and expected result.
Mixing these two result in totally abracadabra (at least to me).
|
|
|