SQL syntax error: missing operator

Question

I have a missing operator error for this query. Can't seem to figure out what the missing operator is!

    SELECT Ordre.Ordre, Sum(Ordre.Duree), Ordre.Designation AS SommeDeDuree 
    FROM Ordre 
    WHERE (((Ordre.Date) > #21/10/2011# And (Ordre.Date) < #25/10/2011#) 
      And ((Ordre.CentreCout) = '5240') And ((Ordre.Ordre) <> 11131906 
      And (Ordre.Ordre) <> 12155996 And (Ordre.Ordre) <> 11147473 
      And (Ordre.Ordre) <> 11147548 And (Ordre.Ordre) <> 11131906)  
    GROUP BY Ordre.Ordre;

You have one more open parenthesis than you do closing.

drdwilcox
– drdwilcox

2011-11-22 17:33:17 +00:00
Commented Nov 22, 2011 at 17:33 — drdwilcox
– drdwilcox, Commented Nov 22, 2011 at 17:33
Done. Just glad to help.

drdwilcox
– drdwilcox

2011-11-22 17:39:30 +00:00
Commented Nov 22, 2011 at 17:39 — drdwilcox
– drdwilcox, Commented Nov 22, 2011 at 17:39

drdwilcox · Accepted Answer · 2011-11-22 17:39:12Z

1

You have one more open parenthesis than you do closing.

answered Nov 22, 2011 at 17:39

drdwilcox

3,97121 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

brpyne · Accepted Answer · 2011-11-22 17:38:26Z

1

SELECT Ordre.Ordre, Sum(Ordre.Duree), Ordre.Designation AS SommeDeDuree 
FROM Ordre 
WHERE (Ordre.Date > '21/10/2011') 
AND (Ordre.Date < '25/10/2011') 
And (Ordre.CentreCout = '5240') 
And (Ordre.Ordre <> 11131906) 
And (Ordre.Ordre <> 12155996) 
And (Ordre.Ordre <> 11147473) 
And (Ordre.Ordre <> 11147548)
And (Ordre.Ordre <> 11131906)
GROUP BY Ordre.Ordre;

answered Nov 22, 2011 at 17:38

brpyne

1,00610 silver badges14 bronze badges

Collectives™ on Stack Overflow

SQL syntax error: missing operator

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related