help with MySQL join

[RHP-997]

Hello All,

I am having trouble writing a MySQL JOIN statement. What I want to do is get a list of web check items with this information (table.column)

applications.name, httptest.name, httpstep.name, httpstep.url

Any help would be appreciated.