i have two tables, table-one and table_two. when i try to join them,

SELECT table-one.clients.ID
FROM table-one.clients
LEFT JOIN table_two.clients
ON table_two.clients.ID = table-one.clients.ID
AND table_two.clients.ID IS NOT NULL

mysql always barfs on the hyphen. if i were to change the hyphen to an underscore it would work. unfortunately the database in question is very large and in production, so i would rather not change the name.

is there a way to escape the hyphen? i have tried \- but that doesn't work.

thanks!