Hello All,

I'm accessing a foxpro table in ASP via ADO unfortunatly i'm having a
bit of an issue. I have a very simple SQL statment thats returning only
one column, strange becouse i'm selecting three. The problem is in how
i'm using the subselect, but it runs quite well in foxpro6 IDE (latest
version i have avalable)

The tables contain 10,000+ rows and the query should return about
300rows (and does). The only issue is that it refuses to return more
then just the first column.

While searching I found this topic (http://tinyurl.com/pxzn5), sounds
like the same problem, but no solution was posted.

Can anyone help?

The SQL (sorry formatting will be lost)
SELECT oo.ODR_DATE,
oo.CUSTNUM,
oo.ORDER
FROM CMS AS oo
WHERE oo.CUSTNUM IN (
SELECT C.CUSTNUM
FROM ITEMS AS I,
CMS AS O,
CUST C
WHERE (
(I.ORDER = O.ORDER)
AND (O.CUSTNUM = C.CUSTNUM)
)
AND I.ITEM = 'PN0010'
)