SQL querry typing in putty

Hi I am trying to type the sql query in Putty server but unable to write the full query .
for example my query is

INNER JOIN [CMDBConfigItemRel] ON [VGE_LocalPortfolio.CIID] = [CMDBConfigItemRel.FromID]

and the Robot typing from above query is only INNER JOIN ON =
what ever inside the braces is not typing
not sure yet why it is typing only that.
any advise would be very helpful

Thank you

Square brackets are used to indicate special keys.
You can escape them by putting double brackets, f.e. like this:
yourString.Replace("[", "[[")
(there’s no need to escape the closing brackets)

1 Like

Thank you Andrzej
I have replaced my string

1 Like