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