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;
Please sign in to leave a comment.
isn't it the same request as previous one?
Not quite. With that change,
turns into
with formatting
It seems that this is not possible. I adjusted my formatting settings such that it always matches the former in my previous comment.