Many thanks Christian, I'll give those a try.

On Tue, 26 Nov 2002 11:32:03,  wrote:
> Here are my solutions:
> 
> SELECT *
> FROM forumSection
> WHERE forumSectionID in (
>  SELECT DISTINCT fs.forumSectionID
>  FROM forumSectionID fs
>   INNER JOIN forumList fl ON fs.forumSectionID = 
> fl.forumSectionID 
>   LEFT OUTER JOIN forumUsers fu ON fl.ForumID = fu.ForumID
>  WHERE fs.forumCategoryID = 5 AND fu.UserID = 84)
> 
> or
> 
> SELECT fs.*
> FROM forumSection fs
>  INNER JOIN (
>   SELECT DISTINCT fl.forumSectionID
>   FROM forumList fl 
>    LEFT OUTER JOIN forumUsers fu ON fl.ForumID = 
> fs.forumUsers.ForumID
>   WHERE fu.UserID = 84) fsd ON fs.forumSectionID = 
> fsd.forumSectionID
> WHERE fs.forumCategoryID = 5
> 
> I hope it will help you,
>


Cheers,

Julian Voelcker
The Virtual World (UK) Limited
Cirencester, United Kingdom