UNIONs and SQL beautifier

[stevec]

Is there anyway to control the formatting applied to UNION SQL's by the beautifier ?
- it generates ...

SELECT codevalue,
       codetext
FROM   uni7live.cncode
WHERE  cncode.listname = 'EHAREATM'
UNION
  SELECT '*',
         '(All)'
  FROM   uni7live.cncode
  UNION
    SELECT '^' AS codevalue,
           '(Not Set)' AS codetext
    FROM   uni7live.cncode
    ORDER  BY 2;

whereas I'd prefer ...

SELECT codevalue,
       codetext
FROM   uni7live.cncode
WHERE  cncode.listname = 'EHAREATM'
UNION
SELECT '*',
       '(All)'
FROM   uni7live.cncode
UNION
SELECT '^' AS codevalue,
       '(Not Set)' AS codetext
FROM   uni7live.cncode
ORDER  BY 2;

 

[Marco Kalter]

The indented union layout was not intentional. We'll fix it.

------------------
Marco Kalter
Allround Automations

 

[stevec]

Excellent

Thanks Marco