SQL Inner-join with 3 tables?

You can do the following (I guessed on table fields,etc)

SELECT s.studentname    , s.studentid    , s.studentdesc    , h.hallnameFROM students sINNER JOIN hallprefs hp    on s.studentid = hp.studentidINNER JOIN halls h    on hp.hallid = h.hallid

Based on your request for multiple halls you could do it this way. You just join on your Hall table multiple times for each room pref id:

SELECT     s.StudentID    , s.FName    , s.LName    , s.Gender    , s.BirthDate    , s.Email    , r.HallPref1    , h1.hallName as Pref1HallName    , r.HallPref2     , h2.hallName as Pref2HallName    , r.HallPref3    , h3.hallName as Pref3HallNameFROM  dbo.StudentSignUp AS s INNER JOIN RoomSignUp.dbo.Incoming_Applications_Current AS r     ON s.StudentID = r.StudentID INNER JOIN HallData.dbo.Halls AS h1     ON r.HallPref1 = h1.HallIDINNER JOIN HallData.dbo.Halls AS h2    ON r.HallPref2 = h2.HallIDINNER JOIN HallData.dbo.Halls AS h3    ON r.HallPref3 = h3.HallID

If you have 3 tables with the same ID to be joined, I think it would be like this:

SELECT * FROM table1 aJOIN table2 b ON a.ID = b.IDJOIN table3 c ON a.ID = c.ID

Just replace * with what you want to get from the tables.

SELECT column_Name1,column_name2,......  From tbl_name1,tbl_name2,tbl_name3  where tbl_name1.column_name = tbl_name2.column_name   and tbl_name2.column_name = tbl_name3.column_name