Help with SELECT statement

[eluser]Samuurai[/eluser]
Hi,

I've only ever done simple SELECT statements, but am trying to advance to the world of JOINS and selecting from multiple tables.

I'm writing an app to track server downtimes for my organisation.

I have 5 tables
One called application which has an id and Name field
One called device which has an id and Name field
One table called "downtime", which has an "id" some fields with data and also application_id and device_id
I also have two lookup tables named downtime_application and downtime_device.

I'm ok with the basic SELECT * FROM downtime, but how do I then use the application_id and device_id do pull the application and device name ?