Syntax error in SQL query

  • Thread starter Thread starter Bren Pierce
  • Start date Start date
B

Bren Pierce

I'm getting a Syntax error (missing operator) in query expression,
‘where_Fact_Orders.Transport_Days >3’.
 
Without seeing the entire SQL statement, I can only guess that this WHERE
clause snippet should be this:

where Fact_Orders.Transport_Days >3
 
Thanks Ken:
Here's the SQL statement

SELECT DISTINCTROW Dim_Shipping_Company.Shipping_Company_Name,
Fact_Orders.Order_Num, Fact_Orders.Order_Shipped_Date,
Fact_Orders.Delivery_Date, Fact_Orders.Transport_Days, 1 AS Order_Count
FROM Dim_Shipping_Company INNER JOIN Fact_Orders ON
Dim_Shipping_Company.Shipping_Company_ID = Fact_Orders.Shipping_Company_ID
GROUP BY Dim_Shipping_Company.Shipping_Company_Name, Fact_Orders.Order_Num,
Fact_Orders.Order_Shipped_Date, Fact_Orders.Delivery_Date,
Fact_Orders.Transport_Days, 1;
 
Your SQL statement does not contain a WHERE clause? Please explain how the
'where_Fact_Orders.Transport_Days >3' text string corresponds to this SQL
statement, and the context in which you're using this text string.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
 
Back
Top