Toad World® Forums

Remove excessive brackets in Query Builder's version of SQL

When using the Query Builder, the SQL generated has a lot of brackets around the table JOINs which are actually unnecessary, and make the code look staggered and messy.


Here is an example of the SQL Toad generated when I joined three tables...Please note the '(' and ')' brackets in the FROM clause.

SELECT tg.TETID,
        tg.YearNum,
        tg.[Year],
        tg.TETName
FROM (AIMSdevelopment.dbo.tblTETMeeting tm
      INNER JOIN AIMSdevelopment.dbo.tblTETMeetingStudent tms
          ON (tm.TETmeetingID = tms.TETmeetingID))
     INNER JOIN AIMSdevelopment.dbo.tblTETGroups tg ON (tg.TETID = tm.TETID)

Ideally it should look like this...

SELECT tg.TETID,
        tg.YearNum,
        tg.[Year],
        tg.TETName
FROM dbo.tblTETMeeting tm
    INNER JOIN dbo.tblTETMeetingStudent tms
        ON tm.TETmeetingID = tms.TETmeetingID
    INNER JOIN dbo.tblTETGroups tg
        ON tg.TETID = tm.TETID

I would like to also request to ability to select a query in the editor and remove redundant parenthesis as well as unnecessary square brackets for field names.