hyphen in database name causing problem with 2xDB join

[jamie]

hi,

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!

[brotherhood of LAN]

`tablename`.`columnname`

using backticks should remedy it

[coopster]

Just adding a resource: identifiers and qualifiers [dev.mysql.com]

[jamie]

many thanks both - works a charm!