Join conditions order option

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

Join conditions order option

Postby cussuol » Thu Oct 28, 2010 11:13 pm

Take the following query:

Code: Select all
SELECT
    *
  FROM
    Child
  JOIN
    Parent
    ON ...


Sql Prompt suggests me:
Code: Select all
... Child.Cod_Parent = Parent.Cod_Parent


But i'd like the join condition were like this:
Code: Select all
... Parent.Cod_Parent = Child.Cod_Parent


Of course, i know they both work as well. But i use to ever list the Parent table before. That's just the way my head works....

Thank you.
cussuol
 
Posts: 10
Joined: Thu Aug 25, 2005 2:48 pm

Postby emoreau » Tue Nov 02, 2010 1:08 pm

+1
emoreau
 
Posts: 38
Joined: Tue May 23, 2006 6:48 pm


Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests