gistfile1.txt

SELECT motor_symptoms.description, profiles_motor_symptoms.id FROM motor_symptoms LEFT OUTER JOIN profiles_motor_symptoms ON motor_symptoms.id=profiles_motor_symptoms.motor_symptom_id WHERE profiles_motor_symptoms.profile_id=11;

SELECT description, profiles_motor_symptoms.id FROM motor_symptoms LEFT OUTER JOIN profiles_motor_symptoms ON profiles_motor_symptoms.motor_symptom_id=motor_symptoms.id;

SELECT ms.description, pms.id
FROM motor_symptoms ms LEFT OUTER JOIN 
            profiles_motor_symptoms pms ON ms.id=pms.motor_symptom_id
WHERE (pms.profile_id=11 or pms.profile_id is NULL);

SELECT description, p.id from motor_symptoms as m LEFT JOIN profiles_motor_symptoms as p on m.id=p.motor_symptom_id;

          description          | id 
-------------------------------+----
 Resting Tremor                |  3
 Slowness                      |  4
 Resting Tremor                |  5
 Slowness                      |  6
 Small Handwriting             |  7
 Resting Tremor                |  8
 Trouble walking/Shuffled Gait |  9
 Slowness                      | 10
 Resting Tremor                | 11
 Slowness                      | 12
 Small Handwriting             | 13
 Resting Tremor                | 14
 Trouble walking/Shuffled Gait | 15
 Trouble walking/Shuffled Gait | 22
 Slowness                      | 23
 Small Handwriting             | 24
 Resting Tremor                | 25
 Falling, poor balance         | 26
 Slowness                      | 27
 Small Handwriting             | 28
 Resting Tremor                | 29
 Small Handwriting             | 30
 Slowness                      | 31
 Resting Tremor                | 32
 Resting Tremor                | 33
 Trouble walking/Shuffled Gait | 34
 Slowness                      | 35
 Small Handwriting             | 36