extending a Join

[aarontra]

Here is the sql that works:

SELECT Sessions.Title as SessionTitle, Sessions.*, Users.firstName as LPFirstName,
Users.lastName as LPLastName, Users.Email as LPEmail, Users.CampusCompany as LPInstitution
FROM (Sessions LEFT JOIN SessionUsers ON
(Sessions.SessionID = SessionUsers.SessionID
AND SessionUsers.role = 'LeadPresenter') )
LEFT JOIN Users ON SessionUsers.UserID = Users.UserID


I want to add another two tables that will be joined to the
"Sessions" table.
I cannot get it to work.

The tables are Tracks, and Formats
columns to include are
Tracks.TrackName, Formats.FormatName

"Join" or where
Sessions.TrackID = Tracks.TrackID
Sessions.FormatID = Tracks.FormatID

The biggest reason I want to include these columns is I want to be able to "order by" them.

Any suggestions?

Thank you
Aaron

 

[aarontra]

Got rid of the joins and now it works.

Aaron