Greetings All!

I am unable to create a functioning Command on my datatableadapter for the following query in visual studio's dataset designer:

SELECT tleft.modeloptionid, tleft.weboptionimg, tright.modeloptionid, tright.orderdetailid
FROM
(SELECT modeloption.modeloptionid, modeloption.weboptionimg
FROM modeloption
WHERE modeloption.modelid = 2072) AS tleft
LEFT OUTER JOIN
(SELECT orderoption.modeloptionid, orderoption.orderdetailid
FROM orderoption
WHERE(orderoption.orderdetailid = 41367)) AS tright
ON tleft.modeloptionid = tright.modeloptionid

The syntax is recognized and parsed by visual studio, but then visual studio automatically converts the sql text to the following code, which is not understood by the vfpoledb driver:

SELECT tleft.modeloptionid, tleft.weboptionimg, tright.modeloptionid AS Expr1, tright.orderdetailid
FROM { oj
(SELECT modeloptionid, weboptionimg
FROM modeloption
WHERE (modelid = 2072)) tleft LEFT OUTER JOIN
(SELECT modeloptionid, orderdetailid
FROM orderoption
WHERE (orderdetailid = 41367)) tright ON tleft.modeloptionid = tright.modeloptionid }

Can somebody offer some suggestions on how to get this query into a command on my datatableadapter? Thanks!