Select Query Where Results of 1 are not in 2

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Select Query Where Results of 1 are not in 2

Author

Topic

CreativeNRG
Starting Member

44 Posts

Posted - 2008-02-28 : 02:42:17

I have the following view:

SELECT TOP 100 PERCENT dbo.Tournaments.VenueId,
COUNT(dbo.Results.ResultId) AS Total,
dbo.Tournaments.LeagueWeekId,
dbo.LeagueWeeks.LeagueId
FROM dbo.Tournaments
INNER JOIN dbo.Results
ON dbo.Tournaments.TournamentId = dbo.Results.TournamentId
INNER JOIN dbo.Venues
ON dbo.Tournaments.VenueId = dbo.Venues.VenueId
INNER JOIN dbo.LeagueWeeks
ON dbo.Tournaments.LeagueWeekId = dbo.LeagueWeeks.LeagueWeekId
WHERE (dbo.Tournaments.Status = 2)
GROUP BY dbo.Tournaments.VenueId,dbo.Tournaments.LeagueWeekId,dbo.LeagueWeeks.LeagueId
ORDER BY dbo.Tournaments.VenueId,
dbo.Tournaments.LeagueWeekId

From this view I want to extract all venue ids from 1 league( dbo.LeagueWeeks.LeagueId) that are not in another leagaue( dbo.LeagueWeeks.LeagueId)

Any help would be much appreciated.

www.creativenrg.co.uk

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources