0

Dear all

i'm getting an error with the code below

The Error....

SQL Syntax Errors Encountered

Error in Select clause: expression near 'DESC'.
Missing from clause
Unable to parse query text

Any ideas....

I'm using...

  • Visual Studio 2010
  • .DBF Database
  • Foxpro
  • Building Windows app
SELECT        product.code, product.DESC, ullage.counttotal
FROM            product LEFT JOIN
                         ullage ON product.code = ullage.code
ORDER BY product.code
Attachments Error.jpg 32.77 KB
2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by Teme64
0

I'm not familiar with FoxPro but DESC is related to ORDER BY. With "standard" syntax the query should be

SELECT product.code, ullage.counttotal
FROM product LEFT JOIN ullage ON product.code = ullage.code
ORDER BY product.code DESC

HTH

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.