Browse 549 attributed reviews, viewable separately for our classroom and online training

Details for bhilarev

bhilarev has participated in the following threads:

Added by bhilarev on 25 Oct 2017 at 07:14

I just get only four rows ,

Select
x.AuthorName,y.EpisodeNumber,y.Title,y.EpisodeDate
From Author As x
INNER JOIN Episode As y
ON x.AuthorId = y.AuthorId
Where Title Like '%Daleks%';

Is this query correct?

Added by bhilarev on 26 Oct 2017 at 10:23

Select EventName,EventDetails,CountryID
From EventInfo
Where CountryId NOT IN
(
Select Top 30 CountryID
From Country
Order By CountryName Desc
)
And CategoryID NOT IN
(
Select Top 15 CategoryID
From Category
Order By CategoryName Desc
)