Ошибка в запросе....

SELECT * FROM forums AS f
INNER JOIN
(SELECT * FROM events AS t
INNER JOIN
(SELECT * FROM discus AS d WHERE d.[id]=77) AS ds
ON ds.[theme]=t.[id]) AS tm
ON f.[id]=tm.[forum]

Server: Msg 8156, Level 16, State 1, Line 1
The column 'id' was specified multiple times for 'tm'.

Ошибка говорит о том, что в подзапросе tm несколько полей с одинаковым именем 'id'.

SELECT * FROM events AS t INNER JOIN discus AS d ON d.[theme]=t.[id] INNER JOIN forums AS f ON f.[id]=t(или d).[forum] WHERE d.[id]=77

Все разобрался.... заработало.....