SQL-problem

Får följande felkod i min SQL-sats...

Microsoft JET Database Engine error '80040e14'
Syntax error in FROM clause.
/forumdisplay.asp, line 32

"SELECT iif(maxDate is null,ThreadPosted,maxDate), author,subject from ((SELECT (select max(ThreadPosted from t_threads where answerid = t.threadid) as maxDate, ThreadPosted, author, subject from t_threads t) dt order by 1 desc"

Någon idé om vad som är fel?

Chansar på det här:

SELECT 
	iif(maxDate is null,ThreadPosted,maxDate) AS col1,
	author,
	subject 
FROM
	(
		SELECT 
			(
				select 
					max(ThreadPosted)
				from 
					t_threads 
				where 
					answerid = t.threadid
			) as maxDate,
			ThreadPosted, 
			author, 
			subject 
		from 
			t_threads t
	) dt
order by 
	col1 desc

Får upp föjande felkod nu när jag kör SQL-satsen...

Microsoft JET Database Engine error '80040e10'

No value given for one or more required parameters.

/forumdisplay.asp, line 35