I have a database with patients and the time their temperature was taken and the temperature value. I would like to pull the patient name and the first four temperatures taken and show them all on the same line. In other words the record would look like
Joe Smith, 98.6, 97.9, 98.0, 99.0
I was wondering how I can do this?
thank you for all your help!