Toad World® Forums

Invalid Character Error when trying to join a column which has a special character in it's name


I have a column named xxx$$,zzz in table A and yyy$$ in table B and zzz in table C
When i am trying to join

SELECT$$, c.zzz from A,B,C
and c.zzz=a.zzz

it's throwing me an invalid character error???

Any ideas on how to fix this??

At what line/column/offset does the error occur?
Could you copy the full error details here? (or partial screenshot)

Thanks for the reply.
Fixed the issue.
There was some spacing issue