Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Intellisense

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Ability to flip the sides in an auto generated join clause

When I write a join statement I put the last table that I am joining to the other tables on the left side of a join clause. For example:
SELECT *
FROM tblOrder o
INNER JOIN tblIOrder_Detail d
ON d.OrderID = o.OrderID
The auto-generated join clause would be "ON o.OrderID = d.OrderID". It would be nice if it was possible to customize this behaviour to choose which side there will be each table/alias on.

Thanks

27 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Roman Tumaykin shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Alister Main commented  ·   ·  Report

    Indeed this could be a deal-breaker for our business too....we would most certainly adopt one product across all developers.

  • Craig Byren commented  ·   ·  Report

    Yes please - Only spotted this request after posting same. Without this option I won't enforce SQL Prompt for our developers as all joinse would have to be reformatted to comply with internal standards.

  • Paul White commented  ·   ·  Report

    +1 this is an annoying default with no option to customize

  • Stephen commented  ·   ·  Report

    I've used the suggested convention for 8 years and have had to edit every auto-join SQL Prompt has developed since v2.0. This looks like a simple enhancement (option setting). Chances of inclusion, RG? High, I hope :)