Resolution
You may receive the error "Error 102: Incorrect syntax near..." when testing a segment if the table you're joining in the segment name starts with numbers.
This is because a table name that starts with a number cannot be joined in a segment.
To resolve the issue, rename the table to a name that does not start with a number and update the table name in the Advanced tab of the segment.