Help with SELECT statement

[eluser]bgreene[/eluser]
select t.*,a.name as appname,d.name as devname from downtime t
left join application a on a.id = t.application_id
left join device d on d.id = t.device_id

use "left join" rather than "join" because in the case of eg an invalid
device_id in the downtime table ie the value is not in the device table,
then the downtime event will still show up in your query result but with
null as devname