>Try
>

>SELECT TOP 3 Event.Title,Event.Url,Event.NoProvince,Province.Code,Event.City,Event.Date,Event.NoCompany,
> Company.Title AS Company,Event.Url,Event.NoAlbum,Album.Url AS AlbumUrl,
> F.PhotoCount
> FROM Event (NOLOCK)
> LEFT JOIN Province ON Event.NoProvince=Province.Numero
> LEFT JOIN Company ON Event.NoCompany=Company.Numero
> INNER JOIN Album ON Event.NoAlbum=Album.Numero
>CROSS APPLY (SELECT COUNT(*) FROM Photo WHERE Album.Numero=Photo.NoAlbum) F
> WHERE Event.NoSite=@NoSite AND Event.NoAlbum>@NoAlbum
>  AND F.PhotoCount >=7
> ORDER BY Event.Date DESC 
>

Thanks, I will keep the other approach. It makes it simpler to understand. But, it is good to know this can be accomplished using that approach as well.