I recently was creating a form that had questions with punctuation in them which caused an issue with the mysql views module.

Adding the table via the mysql views admin page (/admin/content/webform/mysql) appeared to work indicated a successful message "1 table added"
However, the table was not added, and looking at watchdog I found a php error indicating that there was an "incorrect table name" being set, below is the full error.

Incorrect column name 'is_there_anything_you_would_like_your_trainer_to_know_about_you_before_you_arrive' query: CREATE OR REPLACE VIEW webform_views_white_belt_welcome_form AS SELECT parent.sid, s.uid,(SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 1) AS `first_name`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 2) AS `last_name`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 3) AS `street_address`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 4) AS `city_state_postal_code`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 5) AS `phone`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 6) AS `email`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 7) AS `what_field_or_profession_are_you_in`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 8) AS `signup_nid`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 9) AS `have_you_taken_a_nia_class`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 11) AS `for_how_long_have_you_taken_nia_classes`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 13) AS `other_reason`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 15) AS `what_do_you_hope_to_gain_from_your_experience_at_the_white_belt`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 16) AS `how_did_you_find_out_about_this_nia_white_belt_training`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 17) AS `please_name`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 18) AS `please_list_source`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 19) AS `how_did_you_first_learn_about_the_nia_white_belt_training`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 20) AS `please_name_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 21) AS `please_list_source_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 22) AS `do_you_intend_to_teach_nia`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 23) AS `why_or_why_not`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 25) AS `learn_about_the_livelihood_membership`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 26) AS `what_nia_products_do_you_have_experience_with`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 28) AS `if_not_in_this_event`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 29) AS `is_there_anything_you_would_like_your_trainer_to_know_about_you_before_you_arrive`, s.submitted, s.remote_addr FROM webform_submitted_data AS parent JOIN webform_submissions s ON s.sid = parent.sid WHERE parent.nid = 76246 GROUP BY parent.sid ORDER BY parent.sid DESC in /var/www/nianow.com/htdocs/sites/all/modules/webform_mysql_views/webform_mysql_views.module on line 121.

The fields that caused issue had punctuation in the label like apostrophe or comma, question marks were not an issue.

To fix, I set the name of the form field to something very basic when initially adding the field. Then on the field edit page I changed the label to what it needed to be, punctuation included.

This solved the problem for now...