Page 1 of 1

The SQL Formating result is not look very well

PostPosted: Mon May 25, 2015 6:01 am
by Jin Quankai
Hello

About the result of the sql formatting, I would like the formatting result is like the following

SELECT
A.a1,
A.a2,
B.b1,
B.b2,
C.c2
FROM A
INNER JOIN B
ON B.a1 = A.b1
INNER JOIN C
ON C.c1 = A.a1
WHERE
A.a2 LIKE 'aa%'

But, the actual result is like this,
when the complex sql is formated, the result is not very understandable.

SELECT
A.a1,
A.a2,
B.b1,
B.b2,
C.c2
FROM
A INNER JOIN B
ON B.a1 = A.b1 INNER JOIN C
ON C.c1 = A.a1
WHERE
A.a2 LIKE 'aa%'