SQL query via ODBC: referencing table name containing period
I'm using an ODBC connection to send SQL queries to a FM11 database. When I try to reference a table that has a period in its name, FileMaker seems to ignore the part before the period. For example, the following query
SELECT * FROM Loc.Assignment
will return the error
[FileMaker][FileMaker] FQL0002/(1:18): The table named "Assignment" does not exist.
Is there a way to escape the period or delimit the table name? Am I misuderstanding the semantics of a period in a FM table name? It's not my database, so I can't simply rename the table that contain periods. Thanks!