mysqli - MySQL Select- Show Result based on mapped tables -

I have 2 mysql table, the first table activity a patient activity level as an integer Archives, maps the second table of each integer with details. I am trying to make a selected question which gives details of the patient's activity rather than the integer value.

  Activity table ID | Pied | Bath | Cognition | Housekeeping | Dressing | Food | Meals 1 | 20 | 4 | 4 | 2 | 6 | 8 | 4 2 40 4 | 2 | 4 | 4 | 6 | 6 mapping table value. Details 2 | Free 4 | Min 6 Medium 8 Maximum Required Query Id. CID | Bath | Cognition | Housekeeping | Dressing | Food | Meals 1 |  has seen using mysql [case] [1] but it does not seem to work. I have also reviewed these two stack overflow questions [Question 1] [2] and [Question 2] [3] They really did not look like I was watching. Any help would be appreciated.  
  
 
 
 The following code uses your mapping table to display the correct code. Select the MYSQL documentation ID on the selection, PID (Select value from mapping where value = A. bathing) as 'bath', (select description from mapping where value = one adapter) as 'cognition' (In the form of 'dressing' (select value from mapping where value = A.priding) as 'feeding', select description from mapping as 'housekeeping'. (Select description from mapping where Value = a.meal) from 'food' activity As