Dear All,

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?