Why can not I get any row in a MySQL query from SQL Server?
As I'm obviously not even close to proficient in MySQL, my answer won't really focus on that side of your question.  If the view returns what you are expecting from within MySQL, I suspect the issue is on the SQL Server side.  What driver are you using?  If it's the built-in Microsoft driver for MySQL, I would strongly recommend downloading the MySQL Driver from their site and installing that as a new provider on your SQL Server.  When connecting to other RDBMS systems, I have had significantly better luck using the driver provided by the vendor of that application rather than using the generic driver provided by Microsoft.