Formatting Question in v4

Quick question. I'd like my FROM and JOIN keywords to be left-aligned together. For example:

select field1,field2,field3
from table1 t1
inner join table2 t2
on t1.field1 = t2.field2
where t1.field > 0

formats to:

SELECT field1,
field2,
field3
FROM table1 t1
INNER JOIN table2 t2
ON t1.field1 = t2.field2
WHERE t1.field > 0

which is almost what I want. I'd like the final result to look like this:

SELECT field1,
field2,
field3
FROM table1 t1
INNER JOIN table2 t2
ON t1.field1 = t2.field2
WHERE t1.field > 0

Is this possible?

I just reviewed my posting and the spaces were stripped out. Oops. Here's a screenshot

I don't see any difference. Have you pasted the text or typed it directly?

Ok. I see the screenshot now. Thanks.

Sure this can be done. Here is how

Open SQL Assistant Options -> activate Code Formatting tab -> select formatting style you want to customize, for example, "T-SQL Custom Style 1" -> in the specific statements list on the left choose SELECT, on the right adjust the formatting pattern for this statement as required, you can set spacing for each required element, for example, remove spaces before JOIN -> Click "Test..." button in the top-right corner of the Options dialog to check results, enter some test SQL and see if it does what you want, if yes, close the test box and Apply changes.

That works perfectly. Thanks for you help.

You're welcome.