Aaron,
Sorry I don't have MySQL available to test, perhaps someone else using that backend can help.
>1. You can see the semi-colon in table ";"... in view designer, this will be mistakenly assume it is a cross join
>
>2. the Datatype is wrong, especially true in case mySQL's varchar, in where the view will recognise it is character, but most importantly, the length are wrong.