I have three free tempary foxpro tables and I'm trying to use ADO with the MSDataShape provider. But I keep getting the error message "OLE IDispatch exception code 0 from MSDataShape: Data shape command text contains a syntax error at or near position 13 in the command. The text near the error is: "SHAPE (SELECT date FROM tmpf3"..."

SHAPE (SELECT date FROM tmpf3 ORDER BY date) AS a_tmpf3 
   APPEND ((SHAPE {SELECT date, ctrno FROM tmpf2 ORDER BY ctrno} AS a_tmpf2 
   APPEND ({SELECT * FROM tmpf1 ORDER BY order, wono} AS a_tmpf1 
   RELATE "ctrno" TO "ctrno")) AS WorkOrders 
   RELATE "date" TO "date") AS days

Any Help?