How is this related to 'Query Builder and Schema Designer' category in this Forum?
Please paste the complete (SELECT) statement? You did not miss a COMMA after 'customer_name'?
Also what client returns exactly this error:
“Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'Balance'.”
.. it is not a standard MySQL server or client error.