bobmunkhouse
Technical User
I've got RIGHT JOIN, and rather than it displaying a blank field when there is nothing to find, I need it to display a "0". Kind of like a default value.
below is the SQL used for my query.
SELECT [tblTeam].[TeamID], [qryLeagueWon].[Won] AS Won
FROM qryLeagueWon RIGHT JOIN tblTeam ON [qryLeagueWon].[TeamID]=[tblTeam].[TeamID]
GROUP BY [tblTeam].[TeamID], [qryLeagueWon].[Won];
Please help
below is the SQL used for my query.
SELECT [tblTeam].[TeamID], [qryLeagueWon].[Won] AS Won
FROM qryLeagueWon RIGHT JOIN tblTeam ON [qryLeagueWon].[TeamID]=[tblTeam].[TeamID]
GROUP BY [tblTeam].[TeamID], [qryLeagueWon].[Won];
Please help