WHERE alignment
davidsumlin
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:
Here's what I want:
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:
Answers
in order to move the AND right under the WHERE statement you've to set the "Alignment" property, under Operators, to "To Statement":
CTO @ Engage IT Services s.r.l.
Database Administrator and Team Leader
Microsoft MVP - Data Platform
Staff member of getlatestversion.it community
personal website | blog