Options

WHERE alignment

davidsumlindavidsumlin Posts: 8 New member
in SQL Prompt
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';
Tagged:
· Share on Twitter

Answers

Sign In or Register to comment.