Is there a way to convert an ANSI syntax query into standard syntax and vice versa?
1) Enter the SQL you want converted into the Editor.
2) Right click in the Editor and select ‘Send to Query Builder’.
3) In the Query Builder’s Generated Query tab, you will see your statement. You can toggle between ANSI and standard SQL by selecting and unselecting the ‘ANSI Join Syntax’ button. This button is in the toolbar of the Generated Query tab. The button says ANSI and has a green arrow under it. When this button is unselected, you will see standard SQL displayed.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center