Jake Marx wrote:
*Hi ell,

I have tried the query you kindly submitted, but my SQL software
is
displaying the following error:

*** Error: ')' expected here (TOP)

I think this may be the stumbling block:

Transoft USQL Middleware on Linux RedHat Sculptor 4GL Database

I tried a similar query hitting SQL Server via MS Query (XL 2002),
and it
worked fine even though MS Query couldn't represent the query
graphically.
So maybe the middleware or the DB itself doesn't like the syntax.
You could
try adding/removing parenthesis to see if you can get it to work, but
I
don't have either of those tools, so I can't test it any further.
Good
luck!

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored] *

Thanks again for the reply, Jake.

I suspected that there were some syntax conflicts at play.

I have contacted the supplier of our SQL driver, and Transoft directly,
for some help regarding syntax structure. Hopefully I should hear from
them soon.

Ell


---
Message posted from http://www.ExcelForum.com/