M
MikeB
Why, when I create a query in Access with the design view does Access
put so many brackets in the WHERE clause?
eg.:
SELECT Count(Games.GameNumber) AS [Rated Games]
FROM Games
WHERE (((Games.White)=[Player?]) AND ((Games.Rated)=True)) OR
(((Games.Rated)=True) AND ((Games.Black)=[Player?]));
Isn't this syntactically the same as:
SELECT Count(Games.GameNumber) AS [Rated Games]
FROM Games
WHERE (Games.Rated=True) AND (Games.White=[Player?] OR
Games.Black=[Player?]);
If I open a query in the design view, Access keeps changing the WHERE
syntax and it bothers me.
I'm having a hard time wrapping my head around the set theory of SQL
queries.
put so many brackets in the WHERE clause?
eg.:
SELECT Count(Games.GameNumber) AS [Rated Games]
FROM Games
WHERE (((Games.White)=[Player?]) AND ((Games.Rated)=True)) OR
(((Games.Rated)=True) AND ((Games.Black)=[Player?]));
Isn't this syntactically the same as:
SELECT Count(Games.GameNumber) AS [Rated Games]
FROM Games
WHERE (Games.Rated=True) AND (Games.White=[Player?] OR
Games.Black=[Player?]);
If I open a query in the design view, Access keeps changing the WHERE
syntax and it bothers me.
I'm having a hard time wrapping my head around the set theory of SQL
queries.