WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 525 reviews 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
)