What are the challenges you face when working across database platforms? Take the survey
Options bug

jsreynolds1jsreynolds1 Posts: 84 Silver 1
edited October 20, 2015 4:28PM in SQL Prompt
I typically format things without looking. This one took us about 15 min to figure out what had happened.

It is a delete clause at heart. When SQL prompt formatted it, it made some odd assumptions for joins which weren't there if we changed it simply to a select.
Both top and bottom have been formatted. The bottom you can see the changes it just made (incorrectly) in green.
Note that this is a table joining itself again on a different column.



Sign In or Register to comment.