On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

WHERE alignment

What setting do I need to change to configure the WHERE clause so that the first statement is on the same line as WHERE and AND is left aligned with WHERE?
Here's what I have:
SELECT
	t1.field1,
	t1.field2,
	t2.field3
FROM table1 t1
	LEFT JOIN table2 t2
		ON t1.id = t2.id
WHERE
	t1.field1 = 'something'
	AND t2.field2 != 'else';

Here's what I want:
SELECT
	t1.field1,
	t1.field2,
	t2.field3
FROM table1 t1
	LEFT JOIN table2 t2
		ON t1.id = t2.id
WHERE t1.field1 = 'something'
AND t2.field2 != 'else';

Answers

Sign In or Register to comment.