Unpredictable behavior of the following script :
SELECT * FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.id2= t2.id2
sometimes it provides:
SELECT * FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.id2 = t2.id2
sometimes:
SELECT * FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.id2 = t2.id2
especially if it's inside brackets:
SELECT * FROM (table1 AS t1 INNER JOIN table2 AS t2 ON t1.id2= t2.id2)
settings was not changed during test.
I have tried for SSMS, java and Win app.
Could you please advise what can be wrong?
Thanks in advance
