Member Avatar for dan555

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
Error.jpg 32.77 KB
  • 2 Contributors
  • 1 Reply
  • 190 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by Teme64
Member Avatar for Teme64

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.