>>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.

What is hard to understand in the case I suggested? Besides, it should be better for performance.