Allow WHERE clause conditions to be on both the same line or a new line of the where

Simply put, I would like the following two cases to be acceptable formats for the WHERE clause:

SELECT order_line.order_id, order_line.quantity, pet_toy.id
FROM order_line, pet_toy
WHERE order_line.toy_id = pet_toy.id AND order_line.quantity > 1 AND pet_toy.rating > 3.5;

SELECT order_line.order_id, order_line.quantity, pet_toy.id
FROM order_line, pet_toy
WHERE
order_line.toy_id = pet_toy.id
AND order_line.quantity > 1
AND pet_toy.rating > 3.5;
3 comments
Comment actions Permalink

isn't it the same request as previous one?

0
Comment actions Permalink

Not quite. With that change, 

SELECT order_line.order_id, order_line.quantity, pet_toy.id
FROM order_line, pet_toy
WHERE order_line.toy_id = pet_toy.id AND order_line.quantity > 1 AND pet_toy.rating > 3.5;

turns into

SELECT order_line.order_id, order_line.quantity, pet_toy.id
FROM order_line, pet_toy
WHERE
order_line.toy_id = pet_toy.id AND order_line.quantity > 1 AND pet_toy.rating > 3.5;

with formatting

0
Comment actions Permalink

It seems that this is not possible. I adjusted my formatting settings such that it always matches the former in my previous comment.

0

Please sign in to leave a comment.