Aaron,

Can you post examples of the generated SQL and the correct SQL? Also can you give examples of the fieldtypes that are not working?

>I wonder you have the same problem in creating a view by view designer, it always left joined even there is only ONE table, and even I correct it in SQL statement, restore it back when saved?!
>
>how comes?! is it a bug?
>
>Also, the fieldtypes are not 'd/l' exactly, I need to set it correctly in SQL statement or properties of each field... I don't have the problem in VFP8... is there any bug fix available?