[thelist] Tricky Transact SQL Query

[Paul Cowan]

Oops.. just realised a problem with my own query. That should read:
> 	WHERE
> 		(Issue.ReleaseDate IN (SELECT TOP 5 ReleaseDate FROM
> 		Issue WHERE Issue.pubFK = Publication.pubID
>		ORDER BY ReleaseDate DESC))

(note addition of ORDER BY)

Cheers,

Paul.