I have the following 2 tables:

**Participants**

deviceid, name

**DeviceLocation**

deviceid, gpslocation, timestamp

The DeviceLocation table is populated every few minutes with the latest GPS location of the device.

How can I get a list of all devices and the corresponding gps location and participant name with the **latest** timestamp?