Your company is employing WILDCARD tables within Google BigQuery to execute queries spanning multiple tables that share similar naming conventions. The SQL statement designed for this purpose is encountering an error, resulting in a failure of the query. Identify the table naming pattern that will resolve the error and ensure the SQL statement works correctly.