Toad World® Forums

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

Hi,

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 a.xxx$$, c.zzz from A,B,C
where a.xxx$$=b.yyy$$
and c.zzz=a.zzz

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

Any ideas on how to fix this??
Thanks,

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
Thanks,