Why is the 'AS' table alias keyword required in Visual Studio (Database projects)
I think this is happening because you're qualifying the database name in the query.

So remove **DBName** form the select clause; Visual Studio would then accept it.