I think you overcomplicated the query with derived tables. the following query should return the same result

SELECT tleft.modeloptionid, tleft.weboptionimg, tright.modeloptionid, tright.orderdetailid
FROM modeloption tleft
LEFT JOIN orderoption tright 
	ON tleft.modeloptionid = tright.modeloptionid
		AND tright.orderdetailid = 41367
WHERE tleft.modelid = 2072

>
>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!